This Tip is the second in a two-part series looking at the performance impact of large multi-column IN lists in YugabyteDB. In […]
Read More
Reduce YSQL Planning Overhead with Stable SQL and UNNEST
A multi-column IN predicate is a convenient way to perform a batch of point lookups: SELECT item_id, description, category_id, state_code, lookup_hash, version, […]
Read MoreReduce Master Reads During YSQL Connection Churn with Authentication Caching
Applications that frequently open and close YSQL connections can generate more database work than the SQL being executed might suggest. Every fresh […]
Read MoreBetter Patterns for Case-Insensitive Search in YSQL
Case-insensitive search is a common requirement for usernames, email addresses, product names, search boxes, and many other application fields. A previous YugabyteDB […]
Read More