Oracle 26ai JOIN TO ONE under the hood: the real CBO transformations, implicit LEFT OUTER JOIN semantics, runtime checks, and performance impact.

A closer look at Oracle 26ai JOIN TO ONE: what the new syntax promises, how it works under the hood, and what it means for data warehouses.

Here is an overview of some improvements to Online Statistics Gathering in Oracle Releases 19c-23ai

Do Oracle 26ai CALENDAR functions replace a time dimension? A performance and architecture review covering SQL scope, PL/SQL limits, and star schema impact.

A technical first look at Oracle 26ai CALENDAR functions, exploring syntax, formatting rules, fiscal logic, and practical caveats in analytical SQL.

Learn how implicit RAW-to-VARCHAR2 conversions in Oracle break histograms, hurt optimizer estimates, and how to fix them safely.

TL;DR: You don't have to be a genius to solve problems. And there is no shame in not-knowing or not understanding all the geeky details. Ma...

UUIDs are useful, especially when you expose data in REST APIs, but there are cases where you may want to stick to the good old sequence-based primary key. UUIDs in Oracle Database #JoelKallmanDay UUI...

Learn how implicit RAW-to-VARCHAR2 conversions in Oracle break histograms, hurt optimizer estimates, and how to fix them safely.

Oracle 23ai finally supports MERGE … RETURNING! A long-awaited feature, but still hard to find in the docs.

Explore how Oracle 23ai improves MERGE behavior and error handling, replacing vague ORA-30926 message with clearer, smarter diagnostics.

he Oracle AI Vector Search Professional Certification is designed for Oracle DBAs, AI engineers, and cloud developers to unlock the potential of Oracle Database 23ai to build AI-driven applications. T...

This post explores the behavior of Hybrid Columnar Compression (HCC) in Oracle Exadata while refreshing materialized views with atomic_refresh=true.