Bingjie Miao, Senior Software Engineer, Couchbase | Couchbase Blog

All posts by Bingjie Miao, Senior Software Engineer, Couchbase

Bingjie Miao is a senior software engineer in 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
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. Previous versions of Couchbase only support lookup join and index join. Lookup join and index join works great when the document key from one side of the join...

/ March 5, 2018