Description
create index ix1 on default(distinct pairs(self)) where type = 'user' and address.country = 'United States of America' and gender = 'M'; |
explain select count(*) from default where type = 'user' and address.country = 'United States of America' and gender = 'M'; |
Above query uses Dynamic index. The predicate is matched with index condition. So it become cover through filters. But dynamic index predicate is rewritten but Covers.Expressions() are different index projections are empty.
Incase of array index include Primary_key