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.

Dienstag, 16.06.2015
14:00 - 14:45
Amsterdam 2
Experten
English
Administration
Demo
Pachot

Franck Pachot

CERN
Oracle ACE-DirectorOracle OAK-Table
Currently at CERN, back to consulting at dbi-services in February 2020 Oracle Certified Master 12c, ACE Director, Oak Table member, Co-author of Oracle 12cR2 Multitenant (Oracle Press)

Weitere Vorträge, die Sie interessieren könnten