I need help to figure-out why my query is not using indexCountScan. I am using couchbase 4.0.0 version. I have created below index: CREATE INDEX indx_org ON ctmonitor_t(organizationName) USING GSI My query is as below: select count(*) from ctmonitor_t use index(indx_org) where organizationName!=…

Select Count(*) query is taking 45 seconds (I am using indexes)

geraldss January 3, 2017, 5:01pm 5

Topic		Replies	Views
Why my count queries are slow? Couchbase Server query , n1ql , index	9	409	November 21, 2023
N1QL query count si so slow SQL++	3	797	January 26, 2022
Count query is very slow and returns 0 some times even with indexes and IndexCountScan SQL++ query , index	1	768	March 25, 2021
Slow count query SQL++	7	1525	December 19, 2018
Couchbase count query is so slow SQL++ query	26	3029	December 24, 2018