Optimizing Couchbase N1QL Queries with Composite Global Secondary Indexes
When N1QL queries turn full-table scans on growing datasets, a strategically composite GSI can restore sub-millisecond latency without application changes.
ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
When N1QL queries turn full-table scans on growing datasets, a strategically composite GSI can restore sub-millisecond latency without application changes.
Learn how to query DynamoDB by attributes other than the primary key using Global Secondary Indexes (GSIs), including configuration examples and cost-optimization strategies.
Learn how to add a Global Secondary Index to a DynamoDB table so you can query any attribute, see a CLI example, and understand the limits and pitfalls.
Affected feature Global Secondary Index partitioning for N1QL query execution on Couchbase Server 7.x. Precise goal Identify whether a documented partition-count configuration change, rather than a general cluster resource issue, explains latency that appears only when many concurrent N1QL SELECT statements hit the same bucket and index. Constraints and unce