dbaplus Community

Jul 2, 2018 · Databases

Why Oracle CBO Chose Index Scan Over Full Table Scan: Uncovering Misleading System Statistics

A production Oracle database suffered widespread query failures because collected system statistics gave the optimizer incorrect I/O cost values, causing it to favor index scans over full table scans; the article details the diagnosis, root cause, and a simple fix by deleting the system stats.