Details
-
Bug
-
Resolution: Duplicate
-
Major
-
None
-
6.5.1
-
Untriaged
-
1
-
Yes
-
CX Sprint 196
Description
Setup :
1. 1-node cluster with data & analytics service
2. Default bucket loaded with cbworkloadgen data - 1000 docs.
3. Create an analytics dataset and secondary index -
create dataset default_ds on default
create index default_idx1 on default_ds(name:STRING, age:BIGINT)
4. Connect link Local
5. Run query -
select * from default_ds where age=70 and name in ["pymc171","pymc272"]
6. Check the plan - default_idx1 should be used in the plan
With 6.0.4, default_idx1 is used. But in 6.5.1-6298, default_idx1 is not used. Results are the same in both. Attached are the execution plans from 6.0.4 & 6.5.1.
Attachments
Issue Links
- duplicates
-
MB-38319 [CX] Use secondary indexes with composite key for prefix search
- Closed