Indexing properties
Querying an unindexed property causes the server to scan the entire bucket and check that property on every document. You can create indexes with the following syntax:
CREATE INDEX Index_name ON LearningCouchbase(name)
Here, Index_name
is the name of the index you want to create, LearningCouchbase
is the name of the bucket, and name is the attribute of documents in which you want to create the index.
Tip
One thing you need to remember is that you cannot execute any N1QL query until you create a primary index with the query shown next.
CREATE PRIMARY INDEX ON LearningCouchbase
When you create indexes on a bucket; internally, ...
Get Learning Couchbase now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.