SkillBuilders Welcome  |  Log in
All Oracle Tutorials

How to Tune Oracle 12c SQL with Histograms

Oracle Consultants Available

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.

Dec 11 - Oracle 12c SQL Tuning for Developers and DBAs

This free training is segmented into several separate lessons:

1. Part 1 - The Importance of Histograms   (1:28)  
2. Part 2 - Oracle 11g and 12c Histograms (12c New Features)   (1:54)  
3. Part 3 - The Histogram Demonstration !   (6:01)  
4. Part 4 - Wrap-Up, Conclusions and Advice !   (1:13)  

Date: Jan 8, 2016

View all videos now - Free Online Registration required

Here is a preview:

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