DOAG 2015 Datenbank Präsentation: SQL Plan Directives - the Memory of the 12c Optimizer

Präsentation während der DOAG 2015 Datenbank, die am Dienstag, den 16. Juni 2015 in Düsseldorf stattfinden wird:

SQL Plan Directives - the Memory of the 12c Optimizer

The 12c optimizer can challenge his estimation accuracy, and remember the reason for divergence. This is the way for artificial intelligence in the CBO (Cost-Based Optimizer) to leam from one situation to get better for other situations. We will see documented and undocumented behaviors, practical cases and demos.

Referent: Frank Pachot, dbi services, ORACLE ACE

Mehr:
https://www.doag.org/konferenz/konferenzplaner/konferenzplaner_details.php?id=487230&locS=0&vid=497075