Couchbase 6, N1SQL Order by desc is taking long time

SQL++
, ,
3

Thank you vsr1. This Index Advisor helped me lot. It has given me the below index for my sql which solved performance issue.

CREATE INDEX myindex ON mybucket(type,status,startTimestamp DESC,id,subStatus,interaction,endTimestamp,failureReason,traceID,accountNumberToken,customerID,pcn,name) WHERE ((type = “TYP”) and (status = “FAILED”)) WITH { “num_replica”:1 }