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 MoreUse IN, Not OR, for Multi-Value Lookups
When querying multiple exact values on the same column in YugabyteDB, the difference between IN and OR isn’t just stylistic… 👉 It […]
Read MoreExport Optimizer Statistics with SQL Only (No cbo_stat_dump Required)
In a previous YugabyteDB Tip, we explored how to use cbo_stat_dump to recreate production optimizer behavior in a clean environment: 👉 Recreating […]
Read More