What the Heck is the Oracle Optimizer Doing? Transformations
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 is transforming your queries, perhaps in ways you didn't think it was doing!
Tagged under
Leave a comment
- Speaker:
- Neil Chandler
- Podjetje
- Chandler Systems Ltd