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.

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

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

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