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.
Course info
Level
Intermediate
Updated
Mar 10, 2020
Duration
4h 26m
Table of contents
Course Overview
Getting Started with Indexes
Creating Secondary Indexes in Couchbase
Building Complex Secondary Indexes
Implementing Different Types of Indexes
Understanding Factors That Affect Query Performance
Distributing Query Execution Loads with Pushdowns
Optimizing Query Execution
Description
Course info
Level
Intermediate
Updated
Mar 10, 2020
Duration
4h 26m
Description

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.

About the author
About the author

An engineer at heart, I am drawn to any interesting technical topic. Big Data, ML and Cloud are presently my topics of interest.

More from the author
Design Data Models for Couchbase
Beginner
2h 7m
Sep 29, 2020
Recognize the Need for Document Databases
Beginner
1h 40m
Sep 18, 2020
Integrate Couchbase into Your Data Environment
Intermediate
2h 48m
Sep 15, 2020
More courses by Kishan Iyer
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] hi and welcome to this course. Improve nickel query performance. Using Index is my name is Kishan higher, and I will be your instructor for this course a little about my fell first. I have a master's degree in computer science from Columbia University on her previously worked in companies such as Deutschebank on Web MD. In New York. Right now, I work for lunatic on a studio for high quality video content. Indexes are very interesting. Feature in any database on this also applies to Coach Bass. In this course, we cover the different kinds of index. If you can create and the types of nickel queries they can help with in terms of speeding up their execution, we begin exploring the most basic kind of indexes, which are known as primary in excess. The remainder of the court then focuses on one other kind of index, which, in couch based comes and various flavors, namely the secondary index. At first we look at secondary index of containing just a single field and how one or more of them can be used by a single nickel query. We then move on. The composite index is which contained multiple feels and then discuss their benefits as well as limitations. We then explore more advanced indexes, such as adaptive indexes on partition. Indexes on will also explore concepts such as covering indexes on push downs. We also use the couch with advice feature to get recommendations on indexes, which can be generated for a _______. Finally, we get a glimpse of the analytic service in Couch based, which allows us to run queries against the data in a bucket by splitting them up into data sets off similar documents. Once you're done with this course, you will be quite the expert in the different kind of indexes available in college base and how they can be applied to improve the performance off in nickel queries.