Articles

Couchbase N1QL is a SQL-like language for JSON data. To retrieve and manipulate JSON data effectively, we need appropriate indexes. The rules for creating these indexes can be read here. But that involves too much reading, hence we now have an Index Advisor service that accepts a query and gives out an index recommendation that would meet the expectations of the Couchbase query engine — all without downloading the latest Couchbase server.

This service will provide index recommendations to help DBAs, developers, and architects optimize query performance and meet the SLAs.

Source de l’article sur DZONE

Let’s work with index advisor for query workload.

Overview

As the second feature of Index Advisor released in Couchbase server 6.5 (Developer Preview), the Advisor function extends the scope from advising on a single query to providing index recommendations for query workload and support on session handling. In this article, we look at a brief review of how it works in these two different ways.

You may also like: Indexing Best Practices

Advisor Function On Workload

Advisor function works in the following steps:

Source de l’article sur DZONE