A newer version of this documentation is available.

View Latest

Optimizing Performance

      +

      These guides explain some of the features that you can use to optimize the performance of SQL++ queries.
      This page is for Couchbase Server.

      Prepared Statements

      If you need to execute certain SQL++ 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.