In the previous tip Why Your Index Scan Still Reads Thousands of Rows, the second in our index tuning series, we saw […]
Read More
Why Your Index Scan Still Reads Thousands of Rows
Common questions engineers search for: ● Why is my indexed query still scanning thousands of rows? ● Why does PostgreSQL / YugabyteDB […]
Read MoreHow to Choose the Right Column Order in an Index
Introduction Designing an efficient index is one of the most important skills for optimizing SQL queries. Many developers know that indexes improve […]
Read MoreNo More ANALYZE After CREATE INDEX in YugabyteDB 2025.2
TL;DR Starting in 2025.2.0.0 (and backported to 2025.1.3.0), YugabyteDB automatically updates pg_class.reltuples for both the base table and newly created index after […]
Read More