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.
Loading…
ReadMeFeed / Community knowledge
#composite-index
Real questions. Useful conversations. Find the people who know your stack.
couchbaseMySQL Composite Indexes: Column Order, the Leftmost Prefix Rule, and When They Stop Helping
Composite indexes beat multiple single‑column indexes for multi‑column filters, but only if column order respects the leftmost prefix rule and equality columns come before the range column.
Using Neo4j Composite Indexes for Efficient Multi‑Property Filtering
Learn how to create a composite index that lets Neo4j satisfy equality filters on multiple properties with a single Index Seek, plus limits, verification steps, and rollback.
neo4j