Understanding Oracle's Cost-Based Optimizer
How Oracle's CBO chooses execution plans, why it sometimes gets it wrong, and the practical levers — statistics, histograms, hints, baselines — for fixing bad plans.
Read post →
Tag
3 posts tagged with this topic.
How Oracle's CBO chooses execution plans, why it sometimes gets it wrong, and the practical levers — statistics, histograms, hints, baselines — for fixing bad plans.
A practical look at the engineering behind Exadata — Smart Scan, Hybrid Columnar Compression, Smart Flash Cache, RDMA — and the workloads where it earns its price.
Eight practical PL/SQL patterns that consistently make production code faster, safer, and easier to maintain — with examples.