For larger tables and indexes that are hash-sharded, we can specify the number of initial tablet splits desired as part of the […]
Read More
View Metadata for YSQL/YCQL/System Tablets on a Server
Introduced in YugabyteDB 2024.1.0, the YSQL yb_local_tablets view allows you to easily fetch the metadata for YSQL, YCQL, and system tablets of […]
Read MoreCreating Indexes on ARRAY Columns in YSQL
Secondary indexes boost database performance by enabling faster row retrieval. In YSQL you can create Unique, Partial, Covering, and Secondary Indexes with […]
Read MoreDisplay YSQL Database Size
The Postgres pg_database_size(name) built-in system function retunrs the disk space used by the database with the specified name. Although YugabyteDB is Postgres […]
Read MoreIdentify Unused YCQL Indexes
Yugabyte Cloud Query Language (YCQL) is a semi-relational SQL API that is best fit for internet-scale OLTP and HTAP applications needing massive […]
Read More