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 MoreIdentifying and Removing Redundant Indexes in Your Database
Secondary indexes in YugabyteDB are critical for improving database query performance by allowing faster access to rows. However, like any tool, they […]
Read More