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 →
Category
2 posts in this category.
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.