Across this indexing series, we improved the same query step by step. We started with a simple index on tenant_id. Then we: […]
Read More
How 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 ORDER BY LIMIT Can Change the Best Index in YugabyteDB
In Tip #3, we improved our index so filtering happened inside the index scan. In Tip #4, we saw how IN() predicates […]
Read MoreHow IN() predicates create multiple index ranges
In the YugabyteDB Tip How to Eliminate “Rows Removed by Filter” in YugabyteDB, we improved our index so that filtering happens directly […]
Read More