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.