Best practice for index in query

aponnath · April 3, 2019, 3:44am

If I create an index for a N1QL query, do I need to index all fields that I want to return or only the one used in the where clause for best performance ?

vsr1 · April 3, 2019, 5:02am

Check this out https://blog.couchbase.com/create-right-index-get-right-performance/

Topic		Replies	Views
Basic principles/Best practice for CREATE INDEX in N1QL Couchbase Server n1ql	2	1721	May 15, 2016
Solution On Index SQL++ index	2	978	September 28, 2017
Is there another way to use a specific index, rather than using the use index clause , in a N1QL select query? SQL++	10	1121	November 30, 2018
For N1QL should we create an index for each search and filter predicate for n1ql to be performant? SQL++	1	1739	April 30, 2014
Best practice on n1ql index? SQL++	3	2120	January 6, 2016

Best practice for index in query

Related topics