A multi-column IN predicate is a convenient way to perform a batch of point lookups: SELECT item_id, description, category_id, state_code, lookup_hash, version, […]
Read More
Designing the Best Index for a Query in YugabyteDB
Across this indexing series, we improved the same query step by step. We started with a simple index on tenant_id. Then we: […]
Read MoreHow Covering Indexes Can Eliminate Table Reads in YugabyteDB
In the YugabyteDB Tip, How ORDER BY LIMIT Can Change the Best Index in YugabyteDB, the fitth tip in our index tuning […]
Read MoreHow to Eliminate “Rows Removed by Filter” in YugabyteDB
In the previous tip Why Your Index Scan Still Reads Thousands of Rows, the second in our index tuning series, we saw […]
Read More