Optimizing Performance
This guide explains some of the features that you can use to optimize the performance of N1QL queries.
Prepared Statements
If you need to execute certain N1QL statements repeatedly, you can use placeholder parameters and prepared statements to optimize query reuse.
Index Advisor
In Couchbase Server Enterprise Edition, the Index Advisor can analyze your queries and provide recommended indexes to optimize response times.
Cost-Based Optimizer
In Couchbase Server Enterprise Edition, the Cost-Based Optimizer enables the Query service to create the most efficient plan to execute a query.
Related Links
Refer to the following guide for information on creating and using primary indexes and global secondary indexes.