Hello every one, My question is quite straight-forward. Is there any strategy for the query service to choose the best suited index to execute a query (given that we have several indexes that can be suitable for the query)?

N1QL uses rule based optimization and try to use best possible index. If you think it is not using the right index you can specify by USE INDEX hint. You can refer the articles in http://blog.couchbase.com/wp-content/uploads/2017/03/N1QL-A-Practical-Guide-v2.pdf how query selects index.

@Zak , You can use the USE INDEX feature in your query and pick the one you want. source: https://developer.couchbase.com/documentation/server/4.1/n1ql/n1ql-language-reference/hints.html From there you can use the visual query tool(PLAN) to see for a give query how efficient an index is for you. …

[image] vsr1: http://blog.couchbase.com/wp-content/uploads/2017/03/N1QL-A-Practical-Guide-v2.pdf Thank you @vsr1 , I will surely read this document.

Query service : How it chooses the best index

Couchbase Server

keshav_m January 8, 2018, 3:17am 5

Please use the second edition:
https://blog.couchbase.com/n1ql-practical-guide-second-edition/

and

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

1 Like

Topic		Replies	Views
Solution On Index SQL++ index	2	1050	September 28, 2017
Best practice on n1ql index? SQL++	3	2250	January 6, 2016
Basic principles/Best practice for CREATE INDEX in N1QL Couchbase Server n1ql	2	1821	May 15, 2016
Priority in N1QL indexes SQL++	7	3830	February 17, 2015
N1QL and index - one more selective than another? SQL++ n1ql	1	1672	May 20, 2016

Query service : How it chooses the best index

Related topics