š 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 More