Hi - any details at this stage as to how N1QL is actually implemented - in particular with regard to use of indexes For example, will it be possible to create specific indexes upfront to increase performance or are they dynamically created?

You can create indexes via the CREATE INDEX statement, and these indexes will be used in querying (mainly by the WHERE clause). You can see exact index usage via the EXPLAIN statement.

N1QL Indexing Architecture

SQL++

vakoroteev October 1, 2013, 9:46am 2

deleted (wrong answer)

Topic		Replies	Views
Can N1QL query to stored index or create indexes? SQL++	1	2090	June 21, 2014
Explicitly selecting an INDEX to use SQL++	17	3823	January 13, 2015
What Index should i create for N1QL rest API? SQL++ query	2	765	November 13, 2018
Basic principles/Best practice for CREATE INDEX in N1QL Couchbase Server n1ql	2	1824	May 15, 2016
N1QL querying views SQL++ n1ql	1	1806	January 4, 2016

N1QL Indexing Architecture

Related topics