Published
Learn the new 12c options for creating histograms. See all free video tutorials at http://www.skillbuilders.com/free-oracle-tutorials.
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" and "Top Frequency" type 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" and "Top Frequency" type histograms.
- Category
- Success
Sign in or sign up to post comments.
Be the first to comment
Up Next
Autoplay
-
01:28
How to tune Oracle SQL with Histograms: Part 1 The Importance of Histograms
-
13:39
Oracle SQL Tuning - Oracle Execution Plans for Beginners
-
01:54
Oracle Instance Recovery Tutorial - Module 13 - Oracle - The Incorruptible Database
-
02:28
Oracle SQL Tuning with NOT NULL Constraints
-
00:54
Oracle Database SQL Tuning with Constraints - Lesson 1 of 5
-
05:28
Database-level Storage Analytics for Oracle Database 12c
-
09:47
Oracle Instance Recovery Tutorial - Module 5 - Demo - What Oracle Database does when DML is Executed
-
15:37
SQL Tuning with Oracle Database 12c - Re-Optimizing Execution Plans
-
11:49
How to Tune Oracle Data Guard 12c - Tuning, Upgrade, and Migration
-
14:05
Oracle Autonomous Database – Put Your Database on Autopilot
-
27:26
SQL Tuning for Beginners Part 1 - Tuning Methodology and Basic Optimization Concepts
-
01:54
SQL Tuning with Histograms Part 2 : 12c New Features
-
12:29
Oracle Database 12c Security - Session 3 - Review Oracle Virtual Private Database
-
08:12
Oracle Database SQL Tuning with Direct and Indirect Reads
-
06:47
Running Oracle Database on Oracle Linux on Oracle x86
-
03:02
Oracle SQL Tuning with Foreign Key Constraints
-
08:20
Oracle SQL Tuning - Explain Plan Lies?
-
02:28
Oracle SQL Tuning with Unique Constraints
-
11:11
Database Industry Experts Discuss Oracle Database In-Memory
-
13:26
Oracle Database In-Memory: State of the Database Discussion
-
31:23
Oracle Database In-Memory: Database Innovation Panel
-
02:43
Four Steps to Oracle SQL Tuning - A Methodolgy
