Thanks for the response.
90% of my documents in the bucket are of type “abc” and my requirement is that I want to create index based on different values of name and other fields in the documents for the type “abc”. Having the generic index like CREATE INDEX myTestIndex ON myTestBucket(type, name) WHERE type=’abc’ ; makes my query to have all values of name and other fields. I guess the Index should be constructed based on all required fields like “WHERE type=’abc’ AND (name=’x’ OR name=’y’ OR name=’z’)” and query should be generic like SELECT * FROM myTestBucket USE INDEX (myTestIndex) ; or SELECT * FROM myTestBucket USE INDEX (myTestIndex) WHERE type=’abc’ AND name=’x’;.