A newer version of this documentation is available.

View Latest

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.