hi @vsr1 . We had one below query where user is fetching 7million records and took almost 57s. Is there any way we can further optimize the query. Plan is attached to query SELECT COUNT(*) FROM config A WHERE A.status <> 2 AND A.numtype = 1 AND A.__at > 0 AND A.hpmn= 6029 AND enabled= TRUE A…

CREATE INDEX ix2 ON config(__t, numtype, hpmn, __at, status) WHERE __t IN ["vf-group", "vf-group-range"] AND enabled = TRUE AND TONUMBER(SPLIT(META().id, ":")[2])= 3; SELECT COUNT(1) FROM config A WHERE status <> 2 AND numtype = 1 AND __at > 0 AND hpmn = 6029 AND enabled = T…

Couchbase Query Optimization in CB

Couchbase Server

system Closed October 9, 2023, 5:47am 10

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Couchbase Query Optimization Couchbase Server	7	466	September 20, 2023
Slow covering query performance SQL++ n1ql	1	1447	September 15, 2016
Cover index in Couchbase SQL++	4	632	June 4, 2020
Long n1ql query time SQL++	2	1205	August 17, 2017
N1QL query count si so slow SQL++	3	827	January 26, 2022

Couchbase Query Optimization in CB

Related topics