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:54
SQL Tuning with Histograms Part 2 : 12c New Features
-
11:49
How to Tune Oracle Data Guard 12c - Tuning, Upgrade, and Migration
-
14:05
Oracle Autonomous Database – Put Your Database on Autopilot
-
12:29
Oracle Database 12c Security - Session 3 - Review Oracle Virtual Private Database
-
02:43
Four Steps to Oracle SQL Tuning - A Methodolgy
-
13:39
Oracle SQL Tuning - Oracle Execution Plans for Beginners
-
09:47
Oracle Instance Recovery Tutorial - Module 5 - Demo - What Oracle Database does when DML is Executed
-
00:54
Oracle Database SQL Tuning with Constraints - Lesson 1 of 5
-
11:11
Database Industry Experts Discuss Oracle Database In-Memory
-
03:02
Oracle SQL Tuning with Foreign Key Constraints
-
13:26
Oracle Database In-Memory: State of the Database Discussion
-
31:23
Oracle Database In-Memory: Database Innovation Panel
-
27:26
SQL Tuning for Beginners Part 1 - Tuning Methodology and Basic Optimization Concepts
-
06:47
Running Oracle Database on Oracle Linux on Oracle x86
-
01:54
Oracle Instance Recovery Tutorial - Module 13 - Oracle - The Incorruptible Database
-
02:28
Oracle SQL Tuning with Unique Constraints
-
08:12
Oracle Database SQL Tuning with Direct and Indirect Reads
-
08:20
Oracle SQL Tuning - Explain Plan Lies?
-
15:37
SQL Tuning with Oracle Database 12c - Re-Optimizing Execution Plans
-
05:28
Database-level Storage Analytics for Oracle Database 12c
-
01:28
How to tune Oracle SQL with Histograms: Part 1 The Importance of Histograms
-
02:28
Oracle SQL Tuning with NOT NULL Constraints
