Details
-
Improvement
-
Resolution: Fixed
-
Major
-
5.0.0
-
5.0.0-2671
Description
Indexes created:
CREATE INDEX idx1 ON default(join_yr ASC, join_day DESC, VMs ASC)
CREATE INDEX idx2 ON default(join_yr DESC, join_day DESC, meta().id DESC)
Query issued:
explain SELECT * FROM default WHERE join_yr > 10 ORDER BY join_yr, join_day DESC LIMIT 10 OFFSET 20
This query uses idx1 mostly.
But intermittently it uses idx2.
Example document:
{
"tasks_points":
,
"name": "employee-9",
"mutated": 0,
"skills": [
"skill2010",
"skill2011"
],
"join_day": 9,
"join_mo": 10,
"email": "9-mail@couchbase.com",
"test_rate": 10.1,
"join_yr": 2011,
"_id": "query-testemployee10153.1877827-0",
"VMs": [
,
{ "RAM": 10, "os": "windows", "name": "vm_11", "memory": 10 } ],
"job_title": "Engineer"
}
Attachments
Issue Links
- is duplicated by
-
MB-24399 N1QL: min always using desc index on field and not having limit 1 in explain.
- Closed