Most modern apps want to store semi-structured data as JSON/JSONB, but a lot of legacy or external systems still speak XML. YugabyteDB […]
Read More
When the CBO Doesn’t Choose a Local Covering Index (And How to Work Around It)
📝 Introduction YugabyteDB’s cost-based optimizer (CBO) is designed to pick the lowest-cost execution plan. When using duplicate covering geo-localized indexes, this usually […]
Read MoreAudit Table Stats & Last ANALYZE in YSQL
Ever see a query plan that suddenly flips to a seq scan, or cardinality estimates that are off by 100×? Nine times […]
Read MoreList All Non‑Default GUC Settings
If you’ve ever changed session configuration parameters using SET …, it’s handy to know which settings differ from the defaults. YugabyteDB exposes […]
Read More