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 More
YSQL – 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 MoreDisplay All Universe Node IPs from YCQL
A YugabyteDB universe is comprised of exactly one primary cluster and zero or more read replica clusters. In YCQL we can display […]
Read More