If an online CREATE INDEX command fails, an invalid index may be left behind. These indexes are not usable in queries, so […]
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 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 More