YugabyteDB’s Auto Analyze service helps keep table statistics fresh automatically. These statistics are important because the YSQL planner, including the cost-based optimizer, […]
Read More
No 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 MoreAutomatically keeping table statistics up to date for better query plans
🌟 Introduction In a distributed SQL engine such as YugabyteDB, query performance hinges on the optimizer’s ability to choose the right execution […]
Read MoreAvoid Cache Invalidation When Analyzing Tables
YugabyteDB’s cost-based optimizer (CBO) is a big deal. Turn it on, keep stats fresh, and your plans get smarter, closer to PostgreSQL […]
Read More