How to Tune Oracle 12c SQL with Histograms

How to Tune Oracle 12c SQL with Histograms

Learn how to tune Oracle 12c SQL with histograms!  In this free tutorial, Oracle Certified Master DBA John Watson demonstrates what histograms do (provide correct cardinality), the difference between histogram types (Frequency and Height Balanced).  You will also learn the importance of the auto sample size algorithm in 12c and the new “Hybrid” type histogram.

Free SQL Tuning / Histogram tutorial:

• Introduction and Demonstration   (9:20)   (click on video below)

 

Date: Mar 18, 2015
click to read the Transcript

NOTE: Some corporate firewalls will not allow videos hosted by YouTube.