Advanced Features
Tuning and Query Performance
Refer to the following pages to learn more about query performance.
Group By and Aggregate Performance
N1QL Pushdowns optimize the performance of N1QL queries by supporting GROUP BY and Aggregate expressions.
Covering Indexes
A covering index includes the actual values of all the fields specified in the query, and does not need to fetch the values from the data service. Covered queries are faster and deliver better performance.
Flex Indexes
In Couchbase Server 6.6 Enterprise Edition and later, the Flex Index feature provides the ability for a N1QL query to use a Full Text Search index transparently with standard N1QL syntax.
Cost-Based Optimizer
The cost-based optimizer takes into account the cost of memory, CPU, network transport, and disk usage when choosing the optimal plan to execute a query.