📝 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 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 MoreHow to Disable (and Re-enable) an Index in YugabyteDB
Sometimes you want to temporarily disable an index … for example, to test the optimizer’s behavior without it, benchmark a new candidate […]
Read MoreOrphaned Indexes: Oracle vs. YugabyteDB
If you’re migrating from Oracle to YugabyteDB, you may have run across the concept of orphaned indexes. In Oracle, there are views […]
Read More