Published
Histograms are essential ingredient of Tuning SQL in the Oracle Database. In Oracle 12c there are new features related to Histogram. In this part of this histogram tutorial, Oracle Certified Master John Watson describes the importance of histograms. 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.
- Category
- Success
Sign in or sign up to post comments.
Be the first to comment
Up Next
Autoplay
-
01:32
How to Move a Datafile in Oracle Database - Part 1
-
05:20
How Oracle RAC Cache Fusion Works Part 2 of 6
-
01:54
SQL Tuning with Histograms Part 2 : 12c New Features
-
01:28
Oracle Data Guard in Ten Minutes Part 1
-
06:02
How Oracle RAC Cache Fusion Works Part 1 of 6
-
02:51
High Availability Oracle 12c Flex Clusters Part 1
-
03:17
How to Tune SQL when You Can't Edit the Source Code, Part 1 of 2
-
09:13
How Oracle RAC Cache Fusion Works Part 3 of 6
-
03:40
Oracle 12c Lightning Fast Cloning Tutorial - Part 8
-
27:19
Developing Apps with Oracle Database Cloud Service: Part 1
-
11:49
How to Tune Oracle Data Guard 12c - Tuning, Upgrade, and Migration
-
08:17
Saeco Tune Up Kit Install | Tune Up For What
-
09:20
SQL Tuning with Oracle Database 12c Histograms
-
02:38
Stabilizing Oracle 12c Performance with Baselines Part 1
-
01:36
The Importance of Cloud Technology for Oracle Hospitality
-
11:49
How to Tune Oracle Data Guard 12c - Tuning, Upgrade, and Migration
-
05:59
Oracle APEX 5.0 New Features - Part 3
-
08:51
Oracle VM Server (Logical Domains) - Part 4
-
00:47
DriveStream on the Importance of Oracle Work Life Solutions
-
06:13
Oracle Takes the Lead in Multi-Cloud World—Part 1
-
04:02
Oracle Data Guard in Ten Minutes, Part 2, Demonstration
-
04:06
How & Why to use Oracle PL/SQL Native Compilation - Introduction Part 1 of 2
