A partial index can work perfectly when you test a query with literal values, yet disappear when the same query is executed […]
Read More
The LIMIT Trap: Don’t Rely on Implicit Row Ordering in YugabyteDB
A new index can make a query faster. It can also change which rows come back first. That matters a lot when […]
Read MoreCalculating Row Value Lengths in YugabyteDB
Sometimes in YugabyteDB YSQL, you might want to measure the size of the data in a row… for example, to estimate storage, […]
Read MoreHow to Prevent YugabyteDB YSQL (JDBC) from Switching a Prepared Statement to an Inefficient Plan
Prepared statements are great… until they suddenly aren’t. With the YugabyteDB JDBC Smart Driver (which inherits pgJDBC behavior), a prepared statement is […]
Read More