Improve N1QL Query Performance Using Indexes

This course covers the different kinds of indexes available in Couchbase to help speed up the execution of N1QL queries. The course includes a combination of concepts and labs to demonstrate the creation of indexes and their use in N1QL queries.

Indexes are a very interesting feature in any database, and this is also true of Couchbase. In this course, Improve N1QL Query Performance Using Indexes, you will cover the various kinds of indexes you can create and what kind of N1QL queries they can help with in terms of speeding up their execution. First, you will begin by exploring the most basic kinds of indexes which are known as primary indexes. Next, you will look at secondary indexes containing just a single field and how one or more of them can be used by a N1QL query to improve performance. Then, you will move on to composite indexes containing multiple fields and discuss their benefits and limitations. Finally, you will glimpse the Analytics Service in Couchbase which allows you to run queries against the data in a bucket by splitting them up into datasets of similar documents. Once you are done with this course, you will be quite the expert in the different kinds of indexes available in Couchbase, and how they can be applied to improve the performance of your N1QL queries.

• Course Overview 2mins
• Getting Started with Indexes 41mins
• Creating Secondary Indexes in Couchbase 31mins
• Building Complex Secondary Indexes 33mins
• Implementing Different Types of Indexes 46mins
• Understanding Factors That Affect Query Performance 44mins
• Distributing Query Execution Loads with Pushdowns 28mins
• Optimizing Query Execution 38mins