The performance of your database query optimization is driven by your database stats.
I’ll show you what you may need to do, to ensure well gathered stats to get the best out of the optimizer.
Oracle Statistics are critical to the optimizer and your system performance, whether on-premises, in the Cloud or Autonomous. If your statistics do not reflect your data, the optimizer will be working with incorrect assumptions and you may get poor execution plans. Your stats are always wrong. They contain estimates, guesses, assumptions and analysis of partial data samples. I have seen many weird and wonderful methods to try to get good statistics.
This talk will show my preferred approach to gathering database stats, ensuring you have the best stats that you reasonably can for your data and keeping your execution plans fast, stable and accurate.