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