🌟 Introduction In a distributed SQL engine such as YugabyteDB, query performance hinges on the optimizer’s ability to choose the right execution […]
Read MoreWhen 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 MoreEfficient 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 MoreStoring 128-bit Integers in YugabyteDB (YSQL)
đź’ˇ Intro YSQL (like PostgreSQL) gives us INT (32-bit) and BIGINT (64-bit), but there’s no native 128-bit integer. So what happens when […]
Read More