Tag: plan

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,...

Keshav Murthy
August 7, 2019 | 31 MIN READ
6.5 / cbo / explain / JSON / NoSQL Database / Optimizer / plan / statistics
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...

Keshav Murthy
June 8, 2019 | 2 MIN READ
database / explain / NoSQL Database / Optimizer / plan