Advanced SQL Developer — Medium
Key points
- Statistics provide information on row counts, distinct values, and histograms
- Query optimizer uses statistics to choose the most efficient execution plan
- Stale statistics can result in suboptimal plan selection
Ready to go further?
Related questions