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
-
30:34
Developing Apps with Oracle Database Cloud Service: Part 2
-
02:54
Oracle Takes the Lead in Multi-Cloud World—Part 2
-
08:51
Oracle VM Server (Logical Domains) - Part 4
-
05:59
Oracle APEX 5.0 New Features - Part 3
-
06:02
How Oracle RAC Cache Fusion Works Part 1 of 6
-
05:20
How Oracle RAC Cache Fusion Works Part 2 of 6
-
11:49
How to Tune Oracle Data Guard 12c - Tuning, Upgrade, and Migration
-
01:32
How to Move a Datafile in Oracle Database - Part 1
-
03:17
How to Tune SQL when You Can't Edit the Source Code, Part 1 of 2
-
02:51
High Availability Oracle 12c Flex Clusters Part 1
-
01:36
The Importance of Cloud Technology for Oracle Hospitality
-
03:40
Oracle 12c Lightning Fast Cloning Tutorial - Part 8
-
04:02
Oracle Data Guard in Ten Minutes, Part 2, Demonstration
-
09:20
SQL Tuning with Oracle Database 12c Histograms
-
08:17
Saeco Tune Up Kit Install | Tune Up For What
-
09:13
How Oracle RAC Cache Fusion Works Part 3 of 6
-
02:38
Stabilizing Oracle 12c Performance with Baselines Part 1
-
00:47
DriveStream on the Importance of Oracle Work Life Solutions
-
04:06
How & Why to use Oracle PL/SQL Native Compilation - Introduction Part 1 of 2
-
01:54
SQL Tuning with Histograms Part 2 : 12c New Features
-
11:49
How to Tune Oracle Data Guard 12c - Tuning, Upgrade, and Migration
-
01:28
Oracle Data Guard in Ten Minutes Part 1
