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