What the Heck is the Oracle Optimizer Doing? Part 2 - Plan Costing
When Oracle optimizes your SQL, it works out what it thinks is the best way to execute your statement to retrieve your data as quickly as possible, minimising unnecessary resource usage. This presentation will look at what Oracle is doing. We will use the 10053 trace functionality to show how Oracle uses statistics to cost your SQL access paths, showing what cost really means and how it works, and the impact of messing with system statistics on your database.
Tagged under
Leave a comment
- Speaker:
- Neil Chandler
- Podjetje
- Chandler Systems Ltd