If an online CREATE INDEX command fails, an invalid index may be left behind. These indexes are not usable in queries, so […]
Read More
Creating 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 MoreFaster Index Creation
We use the CREATE INDEX statement to create an index on the specified columns of the specified table. Indexes are primarily used […]
Read MoreEnforce Uniqueness Across Partitions (Option 2)
In a previous tip we learned that Partitioning is another term for physically dividing large tables in YugabyteDB into smaller, more manageable tables […]
Read MoreUsing an Index with LIKE Operator Predicates in YSQL
The YSQL LIKE operator is used to match text values against a pattern using wildcards. If the search expression can be matched […]
Read More