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

Četrtek, 1. junij 17:55 - 18:40
Težavnost: Expert
Dvorana: A
Področje: DBA
Jezik: Angleščina

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.

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.

Speaker:
Neil Chandler
Podjetje
Chandler Systems Ltd