DOAG 2023 Datenbank Präsentation: What the Heck is the Oracle Optimizer Doing? Part 1 - Transformations

Präsentation während der DOAG 2023 Datenbank, die von Mittwoch, den 24. Mai 2023 bis Donnerstag, den 25. Mai 2023 in Düsseldorf stattfinden wird:

What the Heck is the Oracle Optimizer Doing? Part 1 - 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, trying to minimise 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 - rewriting your SQL to allow different access paths and eliminating unnecessary code. I will show how your configuration and schema design influences those decisions, perhaps in ways you didn't think it was doing!

Die Präsentation findet am Mittwoch, den 24. Mai 2023 um 15:15 Uhr im Raum Düsseldorf 1 statt.

Der Referent ist Neil Chandler, Chandler Systems Ltd, ORACLE ACE Director

Mehr:

https://shop.doag.org/events/doag-datenbank/2023/agenda/#eventDay.1684879200