Sonntag, 6. März 2016

DOAG 2016 Datenbank Präsentation: Do you gather statistics in the way the CBO expects them?

Präsentation während der DOAG 2016 Datenbank, die von Dienstag, den 10. Mai 2016 bis Mittwoch, den 11. Mai 2016 in Düsseldorf stattfinden wird:


Do you gather statistics in the way the CBO expects them?

You can't blame the optimizer unless you are sure you feed it with relevant statistics. There is the Auto Job which suits lots of cases, and there are some exceptions: volatile tables, partitioned tables, bulk load, histograms and bind variables, etc. You cannot gather all possible statistics everyday, and you cannot rely on stale ones. Let's define a few rules to know if you gather statistics in the right way, and how latest features can help in 12.1 and next releases. 

Der Vortrag findet am Dienstag, den 10. Mai 2016 um 14:00 Uhr statt.

Der Referent ist Franck Pachot, dbi services, ORACLE ACE

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

Keine Kommentare:

Kommentar posten