From the course: Introduction to Couchbase

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Using JOINs with N1QL/SQL++

Using JOINs with N1QL/SQL++ - Couchbase Tutorial

From the course: Introduction to Couchbase

Start my 1-month free trial Buy for my team

Using JOINs with N1QL/SQL++

“

- [Instructor] Setting JOINs is one clear way to enhance querying. JOINs are connections between information in different document sets. They can increase efficiency and make querying more effective. The best strategy when writing effective JOINs is to let the end result guide the journey. Before completing a JOIN, stop and ask, what information do I want users to see or access? In this example, I'd like users to see more information than what's in one document alone. Let's look at the documents and see what I mean. These two documents have many data points but on the left, an airline code of airline_137 is probably not familiar to my users, so I'll JOIN the right side document with the key airline_137 to give my users the airline name and other details they might need. Because this is a key-value operation and Couchbase is a key-value store, no index is needed for this JOIN. But how does this look in the Capella UI?…

Contents