If you’re migrating from Oracle and miss USER_TAB_PARTITIONS and ALL_TAB_PARTITIONS, you can recreate them in YugabyteDB with two simple views over the […]
Read MoreMigrating Oracle Range Partitions to YugabyteDB (YSQL)
When moving Oracle partitions that omit a lower or upper bound, translate them to Postgres/YSQL using MINVALUE and MAXVALUE. Also remember that […]
Read MoreAudit Table Stats & Last ANALYZE in YSQL
Ever see a query plan that suddenly flips to a seq scan, or cardinality estimates that are off by 100×? Nine times […]
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