I ran this index creation:
create index bucket_fieldA on bucket(fieldA);
select count(1) from bucket where fieldA=1;
(fieldA either exists with value 1 or not exists at all)
The bucket contains 2M documents with 300K with fieldA=1
The query runs and never ends.
How can I troubleshoot this case?