YugabyteDB is a distributed SQL database that offers full PostgreSQL compatibility — which means you can use familiar SQL functions to inspect […]
Read MoreReset Table Statistics
When working with cost-based optimization (CBO) in a distributed SQL database like YugabyteDB, keeping your table statistics accurate is crucial for optimal […]
Read MoreFaster Distributed Transactions with CTEs
When working with distributed databases like YugabyteDB, writing safe, performant, and transactionally consistent SQL can get tricky — especially when your app […]
Read MoreHow to Tell If ANALYZE Was Explicitly Run on a Table in YugabyteDB
In YugabyteDB, collecting up-to-date table statistics is critical when the cost-based optimizer (CBO) is enabled. These statistics guide the optimizer in choosing […]
Read More