What the Heck is the Oracle Optimizer Doing? Part 2 – Plan Costing

Session Abstract: 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. Note: This webinar session not planned for recording, please attend the live session only. Speakers Neil Chandler Database Guy, Chandler