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 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 MoreDisplay Queries that Internal Commands Generate
As you explore the ysqlsh interactive shell, it’s useful to know that you can view the SQL queries executed for each meta-command […]
Read More