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.
Course info
Level
Advanced
Updated
Mar 20, 2020
Duration
3h 7m
Table of contents
Description
Course info
Level
Advanced
Updated
Mar 20, 2020
Duration
3h 7m
Description

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.

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
Recognize the Need for Document Databases
Beginner
1h 40m
Sep 18, 2020
Integrate Couchbase into Your Data Environment
Intermediate
2h 48m
Sep 15, 2020
Architect Document Storage for Couchbase
Beginner
1h 48m
Sep 11, 2020
More courses by Kishan Iyer
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hi and welcome to this course. Optimize nickel queries. My name is Kishan Ira 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 have previously worked in companies such as Deutsche Bank on Web MD. In New York. I presently work for Loony Gone, a studio for high quality video content. The nickel query language in Couch Piece is very powerful and allows a wide variety of operations on document data, given that it becomes crucial to understand how exactly Grady's are executed in order to run them in an optimal manner. In this course, we explore the different ways in which nickel query executions can be optimized. We begin by looking into what query plans are a different faith of involved in the execution. Off nickel queries on various culture based service is which participate inquiry executions. We then delve into the roll off indexes in running nickel queries on Bill A variety off secondary indexes speed up query executions. Next, we create prepared statements to further up to my square ease by skipping the step off generating query plants for each execution. We also cover how monitoring can help us analyze queries which are active on also those which have completed execution. And finally, we look into how replication off pocket in college with can influence query performance. Once you're done with this course, you will have a thorough understanding of the various factors which influence query performance in college based, as well as the tools available to execute them in an optimal manner.