Consider to add a check to prevent unnecessary where-clauses in index creating queries

[mfvanek]

We need a check to prevent unnecessary where-clauses like this
create index idx_table_a on table_a (client_id) where client_id is not null;
when client_id is declared as not null in table