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.
Author Name: Kishan Iyer
Author Description:
I have a Masters in Computer Science from Columbia University and have worked previously as a developer and DevOps engineer. I now work at Loonycorn which is a studio for high-quality video content. My interests lie in the broad categories of Big Data, ML and Cloud.

Table of Contents

• 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