How to Tune Oracle 12c SQL with Histograms
Histograms are essential ingredient of Tuning SQL in the Oracle Database. In Oracle 12c there are new features related to Histogram. In this histogram tutorial, Oracle Certified Master John Watson describes the importance of histograms, the new features in Oracle 12c and demonstrates how to use histograms.
Primer: Histograms collect essential statistics such as data skew and thus accurately predict how many rows a predicate will select. This impacts critical decisions such as join order, join method and access method.
This free training is segmented into several separate lessons:
- Part 1 – The Importance of Histograms (1:28) (click on video below)
- Part 2 – Oracle 11g and 12c Histograms (12c New Features) (1:54)
- Part 3 – The Histogram Demonstration! (6:01)
- Part 4 – Wrap-Up, Conclusions and Advice! (1:13)
Date: Jan 8, 2016
NOTE: Some corporate firewalls will not allow videos hosted by YouTube.