Chang Liu | Couchbase Blog

Author

All posts by Chang Liu

Software Engineer in N1QL Query Team

All Posts
Index Advisor Supports Self-Verification and Index Pushdowns
SQL++ / N1QL Query
Index Advisor Supports Self-Verification and Index Pushdowns

N1QL's ADVISE statement, released in Couchbase 6.6, provides Global Secondary Index (GSI) usage recommendations for each keyspace in your query.

Chang Liu
January 19, 2021 | 7 MIN READ
Index Advisor / Indexing
Index Advisor For Query Workload
SQL++ / N1QL Query
Index Advisor For Query Workload

Overview As the second feature of Index Advisor released in Couchbase server 6.5 (Developer Preview), Advisor function extends the scope from advising on single query to providing index recommendations for query workload and support on session handling. In this article,...

Chang Liu
August 15, 2019 | 5 MIN READ
6.5
Index Advisor for N1QL Query Statement
Index Advisor for N1QL Query Statement

Overview Index advisor is introduced in Couchbase server 6.5 as a developer preview feature. It targets at providing secondary index recommendation to help DBAs and developers optimize N1QL query performance. This version is rule-based, in which the index candidates will...

Chang Liu
August 9, 2019 | 10 MIN READ
6.5