A newer version of this documentation is available.

View Latest

Optimizing Performance

    February 16, 2025
    + 12

    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.