Hi,
I have query like this:
Can you suggest are there anyway to create a cover index for this to speed up fetching time ?
Regards,
Hi,
I have query like this:
Can you suggest are there anyway to create a cover index for this to speed up fetching time ?
Regards,
CREATE INDEX news_type_cate_all2_idx ON News(newsType,cate,dateTimeCreated DESC,parent_cate, alias,content) WHERE (type = “News”)
Checkout Designing Index For Query In Couchbase N1QL in https://blog.couchbase.com/wp-content/uploads/2017/10/N1QL-A-Practical-Guide-2nd-Edition.pdf