I create the following index
CREATE INDEX idx_type ON test(type)
Then I run the following query:
Select distinct type from test
My query does not use the index, can you tell me what I’m doing wrong? Do I have to have a where clause in my index?
My main objective is to get a list of type fields from ALL documents in the bucket.