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 MoreUse PostgreSQL Command Line Tools for YugabyteDB
YugabyteDB is a distributed SQL database built to scale out while maintaining compatibility with the PostgreSQL ecosystem. That compatibility is not just […]
Read MoreAudit Selects on a Table to an Audit Table Using RLS
In PostgreSQL—and by extension, YugabyteDB—there’s no native trigger that fires on SELECT statements. This means we can’t use a traditional AFTER SELECT […]
Read More