Optimize N1QL Queries
This course looks into the various factors affecting the performance of N1QL queries and the options available in Couchbase to optimize their executions. This covers topics such as the Couchbase architecture, indexes, and data replication.
What you'll learn
The N1QL query language in Couchbase is very powerful and allows a wide variety of operations on document data. Given that, it becomes crucial to understand how exactly queries are executed in order to run them in the most optimal manner. In this course, Optimize N1QL Queries, you'll explore the different ways in which N1QL query executions can be optimized. First, you'll begin by looking into what query plans are, the different phases involved in the execution of N1QL queries, and the various Couchbase services which participate in query executions. Next, you'll delve into the role of indexes in running N1QL queries and build a variety of secondary indexes to speed up query executions. Then, you'll create prepared statements to further optimize queries - by skipping the step of generating query plans for each execution. Finally, you'll discover how monitoring can help us analyze queries which are active and also those which have completed execution. Once you’re done with this course, you'll have a thorough understanding of the various factors which influence query performance in Couchbase, and the tools available to execute them in an optimal manner.
Table of contents
- Index Pushdowns 7m
- Grouping and Aggregation Pushdowns 2m
- Demo: Using Ordered Indexes 7m
- Demo: The ADVISE Feature 7m
- Demo: Optimizing GROUP BY Operations 6m
- Demo: Index Selection for GROUP BY Operations 6m
- Prepared Statements 3m
- Demo: Creating Prepared Statements 7m
- Demo: Executing Prepared Statements 8m