In a distributed SQL database like YugabyteDB, understanding where data actually lives is just as important as understanding the schema itself. Once […]
Read More
Map Tablespace Placement to Available Nodes
Tablespaces in YugabyteDB provide a way to control how and where data is stored across a distributed cluster. By defining tablespaces with […]
Read MoreUse the YB_LOCAL_TABLETS Sytem View to Map Table Rows to their Tablets
We learned in the YugabyteDB Tip View Metadata for YSQL/YCQL/System Tablets on a Server about the new (in YugabyteDB 2024.1) system view yb_local_tablets. […]
Read MoreYSQL – Verify Secondary Index Usage
The use of secondary indexes can enhance database performance by enabling the database server to find rows faster. If you create too […]
Read MorePitfalls of Adding a PK to an Existing Table in YSQL
Although it’s possible to add a primary key constraint to an existing table with the ALTER TABLE ADD CONSTRAINT command, it’s best […]
Read More