The Query Plan Visualization Tool is one of the quickest ways to understand your query behavior, with it you can easily identify how your queries will be executed. This knowledge is essential for boosting your queries, as you can get some hints of which types of optimizations should be implemented.
The Couchbase 5.5 the Query Plan Visualization Tool got a brand-new design, which allows you to zoom in/out and rearrange the orientation of the graph. Let’s see an example of how the new interface will look like for a query using UNION:
Query plan in Couchbase 5.5
Query plan in Couchbase 5.0
Let’s see another example of how a query using JOIN will look like:
Query plan in Couchbase 5.5
Query plan in Couchbase 5.0
If you have any questions, feel free to tweet me at @deniswsrosa