🌟 Introduction In a distributed SQL engine such as YugabyteDB, query performance hinges on the optimizer’s ability to choose the right execution […]
Read More
Efficient CIDR Range Lookups Using Expression Indexes
🚀 Introduction YugabyteDB fully supports PostgreSQL’s inet and cidr datatypes, allowing you to store and manipulate IPv4 and IPv6 network addresses. However, […]
Read MoreFast multi-column IN deletes/updates with ROW tuples
Intro 🎁 Have you ever written a simple multi-column IN clause, something like WHERE ROW(a, b) IN ((1, 1), (2, 2)), and […]
Read MoreHow Bloom Filters Supercharge Query Performance in YugabyteDB’s DocDB
Intro In distributed databases, the fastest query is the one that doesn’t touch disk at all. That’s the philosophy behind YugabyteDB’s DocDB […]
Read MoreExtracting and Resetting Slow Query Data from YugabyteDB Anywhere (YBA) via API
YugabyteDB Anywhere (YBA) provides a powerful management and observability layer for your YugabyteDB clusters, including metrics, health dashboards, alerts, and query performance […]
Read More