The YSQL LIKE operator is used to match text values against a pattern using wildcards. If the search expression can be matched […]
Read More
Better Performance on JSONB Data Value Search with a GIN Index
YSQL supports the JSON and JSONB data types which both can store JSON (JavaScript Object Notation) data. JSON stores an exact copy […]
Read MoreMaximum Number of Columns Per Index
The use of indexes can enhance YugabyteDB’s performance by enabling the database server to find rows faster. You can create, drop, and […]
Read MoreYSQL – Verify Secondary Index Usage
The use of secondary indexes can enhance database performance by enabling the database server to find rows faster. If you create too […]
Read More