Sometimes you want to temporarily disable an index … for example, to test the optimizer’s behavior without it, benchmark a new candidate […]
Read More
Orphaned 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 MoreHow to Index Encrypted Data in YugabyteDB Using SHA-256 Hashes
Storing sensitive information like Social Security Numbers (SSNs) securely is non-negotiable… but what happens when you need to search or index that […]
Read MoreHow to Identify Index Partitioning Method in YugabyteDB (HASH vs. RANGE)
When working with YugabyteDB, especially in large or distributed deployments, understanding how your tables and indexes are partitioned is critical for performance, […]
Read More