I have a simple trip document and it has a property called startTs that represents the start of the trip. Here is the index that I created CREATE INDEX idx_test ON trips(startTs) WHERE (type = “trip”) And here is my query SELECT RAW trips FROM trips WHERE startTs BETWEEN “0001-01-01T00:00:00…

Index will have entries in ASC order. If query needs DSC it must get all qualified documents and do sort. There is no RVERSE scan. Use DESC index like below. CREATE INDEX idx_test ON trips ( startTs DESC ) WHERE ( type = “trip”);

Index Service Returns All Documents and then it Sorts

SQL++

vsr1 September 22, 2020, 12:48am 11

Any value can still work

Topic		Replies	Views
Access to index without SQL++ query SQL++ query , n1ql	58	263	May 19, 2025
Advice on creating an index for good performance SQL++	7	1509	January 19, 2022
Query taking time even after using covering index (Couchbase 4.6.4 EE) SQL++ query , n1ql , index	20	2384	March 19, 2018
Create Secondary Index on Array SQL++ index	14	2886	October 27, 2017
Long query exec time despite using index SQL++	7	1472	July 5, 2018

Index Service Returns All Documents and then it Sorts

Related topics