Tag: Query optimization

Query Service Memory Management in Couchbase
Query Service Memory Management in Couchbase

Couchbase Query Service manages memory efficiently with quotas, per-query limits, and node-wide settings to optimize performance and resource utilization.

Couchbase’s Cost-Based Optimizer for JSON is patent pending
Couchbase’s Cost-Based Optimizer for JSON is patent pending

With NoSQL databases proving their worth over the legacy SQL approach, the next question is inevitably “how do we optimize our processes as much as possible?” Many databases have used static Rule-Based Optimization (RBO) to optimize workloads – but this...

Index Advisor Service for N1QL (June refresh)
Index Advisor Service for N1QL (June refresh)

This is our June drop for Index Advisor service for N1QL after fixing some of the bugs that were found after our last refresh in May. We plan to keep improvising the Index Advisor service(What is it?). The fixes in...

Index Advisor Service for N1QL (March refresh)
Index Advisor Service for N1QL (March refresh)

This is our March drop for Index Advisor service for N1QL after fixing some of the bugs that were found after our last refresh in Feb. We plan to keep improvising the Index Advisor service(What is it?). The fixes in...

Index Advisor Service for Couchbase N1QL(Feb refresh)
Index Advisor Service for Couchbase N1QL(Feb refresh)

Follow-up blog for recent defects fixed in Couchbase Index advisor provides secondary index recommendations for SQL-like queries on JSON documents to improve query performance.

Index Advisor Service for Couchbase N1QL(SQL for JSON)
Index Advisor Service for Couchbase N1QL(SQL for JSON)

Couchbase Index advisor provides secondary index recommendations for SQL-like queries on JSON documents to improve query performance.