Advanced Query Features

      +

      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.

      SQL++ Support for Couchbase Transactions

      SQL++ offers full support for Couchbase ACID transactions.

      Flex Indexes

      Flex Indexes enable a SQL++ query to use a Search index transparently with standard SQL++ syntax.

      Time Series Data

      In Couchbase Server 7.2 and later, SQL++ enables you to store and query time series data.