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