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