Tag: Optimizer

Less Is More: Why Use a Cost-Based Optimizer?
Less Is More: Why Use a Cost-Based Optimizer?

Couchbase includes a cost-based optimizer (CBO). Learn how having a CBO improves query performance and how to implement it.

Cost Based Optimizer for Couchbase N1QL (SQL for JSON)
Cost Based Optimizer for Couchbase N1QL (SQL for JSON)

Authors & Engineering Team: Bingjie Miao, Keshav Murthy,  Marco Greco, Prathibha Bisarahalli. Couchbase, Inc.  A rule-based optimizer knows rules for everything and cost for nothing – Oscar Wilde Abstract Couchbase is a distributed JSON database. It provides distributed data processing,...

N1QL (Query) Basic Order of Execution.
N1QL (Query) Basic Order of Execution.

Query syntax is limited. Queries are unlimited. Predicate pushdown, group by pushdown, offset pagination, keyset pagination, join optimization, search optimization, we’ve discussed it all. Still, it’s important to understand the default, simple — albeit slow — execution flow of the...

Approaches to Query Optimization in NoSQL
Approaches to Query Optimization in NoSQL

The NoSQL and query optimization tool evaluates the possibilities and selects the efficient plan. Find out what to do when you don’t have a good optimizer.

N1QL: A Practical Guide
N1QL: A Practical Guide

This book is a compilation of articles on NoSQL concepts, N1QL features, optimization techniques, tools and use cases by N1QL R&D team, solution team from Couchbase.