Phoenix Secondary Indexes vs Row-Key Range Scans
Choose between Phoenix secondary indexes and row-key range scans, then validate with EXPLAIN before and after index creation.
Loading…
ReadMeFeed / Community knowledge
#secondary-index
Real questions. Useful conversations. Find the people who know your stack.
Using Apache Phoenix Secondary Indexes Without Slowing Writes
Speed up non-row-key lookups in Apache Phoenix with secondary indexes, but verify planner selection with EXPLAIN and account for write amplification.
When to Use Aerospike Secondary Indexes: Memory Trade‑offs and Query Performance
Learn how Aerospike secondary indexes speed up non‑primary‑key queries, what memory and latency costs they add, and how to decide which bins to index.
aerospikeUsing Phoenix Secondary Indexes to Speed Non-Key Queries on HBase
Filtering a Phoenix table by a non‑key column forces a full table scan. Adding a secondary index turns that scan into an index lookup, cutting read latency while adding modest write overhead.
Selecting Secondary Index Types in Apache Phoenix: Global vs. Local
Compare Global and Local secondary indexes in Apache Phoenix to balance write throughput and read latency in HBase-backed applications.
Using Apache Phoenix Secondary Indexes for Low‑Latency Queries: Architecture Note
Architecture note on adding a single‑column Phoenix secondary index: requirements, minimal design, consistency boundaries, operational checks, failure modes, and when to revisit the design.
Speeding Up Ad‑Hoc Queries in Couchbase with Targeted Secondary Indexes
Learn how to add a Couchbase secondary index that turns expensive full‑bucket scans into fast index‑only lookups, with a concrete example, verification steps, and trade‑offs.
couchbaseAerospike Predicate Filtering: Trimming Query Results Without Dropping Your Indexes
Learn when Aerospike server-side predicate filtering reduces network payload alongside secondary indexes, and why it doesn't replace indexing.
Optimizing Data Retrieval with Aerospike Secondary Indexes
Learn how to implement and optimize Aerospike secondary indexes to retrieve records by non-key bins, including Java client examples and critical memory considerations.