Secondary indexes boost database performance by enabling faster row retrieval. In YSQL you can create Unique, Partial, Covering, and Secondary Indexes with […]
Read More
Display 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 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 MoreDetermining if a YugabyteDB Universe is Running a YSQL or YCQL Workload
The YugabyteDB Query Layer (YQL) serves as the main interface, enabling applications to interact through client drivers. This layer handles API-specific tasks, […]
Read MoreANALYZE All Tables in the Current Database
In YSQL the ANALYZE command collects statistics about the contents of tables in the database, and stores the results in the pg_statistic system […]
Read More