Tablespaces in YugabyteDB provide a way to control how and where data is stored across a distributed cluster. By defining tablespaces with […]
Read More
Use 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 MoreDrop a YCQL Keyspace Which is Not Empty
In YCQL the DROP KEYSPACE statement is used remove a keyspace from the system. An error is raised if the specified keyspace […]
Read More