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 MorePresplit a Materilized View into a Specific Number of Tablets
For larger tables and indexes that are hash-sharded, we can specify the number of initial tablet splits desired as part of the […]
Read MoreView 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 YugabyteDB Universe Cluster Configuration Details in HTML, JSON or Text Formats from the Command Line
The cluster configuration in YugabyteDB provides information about the current state of the cluster. It includes details about the replication settings, placement […]
Read More