Bingjie Miao, Principal Software Engineer, Couchbase | Couchbase Blog

Author

All posts by Bingjie Miao, Principal Software Engineer Couchbase

Bingjie Miao is a principal software engineer at Couchbase. Bingjie has 20 years of experience in relational and NoSQL databases. His main area of expertise is query optimization and query execution.

Analyzing Statistics for Cost-Based Optimization in Couchbase 7.0

Analyzing Statistics for Cost-Based Optimization in Couchbase 7.0

Couchbase Server 7.0 (Enterprise Edition) introduced a Cost-Based Optimizer (CBO). Previous versions of Couchbase Server used a Rule-Based Optimizer (RBO). Couchbase Server has naturally evolved from RBO to CBO like most major relational database systems. The CBO uses cost estimates...

IN List Handling Improvements in Couchbase Server 6.5

IN List Handling Improvements in Couchbase Server 6.5

Introduction IN list is commonly used in N1QL queries. Couchbase Server 6.5 introduces a couple of enhancements in handling of IN list in N1QL queries. Handling of Large IN List Before Couchbase Server 6.5 N1QL handles IN list evaluation at...

ANSI JOIN Enhancements and  ANSI MERGE

ANSI JOIN Enhancements and ANSI MERGE

Introduction N1QL support for ANSI JOIN was first introduced in version 5.5. Currently there is a restriction in ANSI JOIN (version 5.5 and 6.0) in that the right-hand side of an ANSI JOIN must be a keyspace. This restriction will...

ANSI JOIN Support in N1QL

ANSI JOIN Support in N1QL

Overview ANSI JOIN support is added in N1QL to Couchbase version 5.5. In previous versions of Couchbase, join support was limited to lookup join and index join, which works great when the document key from one side of the join...