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.

All Posts
Analyzing Statistics for Cost-Based Optimization in Couchbase 7.0
AnalyticsCouchbase ServerN1QL / Query

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

January 25, 2022
Couchbase ServerN1QL / Query

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

February 17, 2020
Couchbase ServerN1QL / Query

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

January 21, 2020
Best Practices and TutorialsCouchbase ServerN1QL / Query

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

March 5, 2018