Secondary indexes boost database performance by enabling faster row retrieval. In YSQL you can create Unique, Partial, Covering, and Secondary Indexes with […]
Read More
Faster 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