Published
Learn how to tune SQL - especially in Data Warehouse environments - with Constraints. Constraints provide critical information to the Cost Based Optimizer in the Oracle Database. Don't drop your constraints for query performance! In these 5 lessons, Oracle Certified Master DBA John Watson will demonstrate how constraints - unique, foreign key, not null - improve the execution plan and thus performance of SQL in an Oracle database. View all 5 lessons, free at http://www.skillbuilders.com/oracle-database-sql-tuning-with-constraints.
- 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
-
02:43
Four Steps to Oracle SQL Tuning - A Methodolgy
-
12:29
Oracle Database 12c Security - Session 3 - Review Oracle Virtual Private Database
-
07:44
Common Oracle SQL Tuning Errors - Lesson 1 Validate and tweak the Design for SQL Performance
-
27:26
SQL Tuning for Beginners Part 1 - Tuning Methodology and Basic Optimization Concepts
-
13:26
Oracle Database In-Memory: State of the Database Discussion
-
00:49
When to use Oracle Database Bitmap Indexes Lesson 1
-
11:11
Database Industry Experts Discuss Oracle Database In-Memory
-
02:28
Oracle SQL Tuning with Unique Constraints
-
15:37
SQL Tuning with Oracle Database 12c - Re-Optimizing Execution Plans
-
05:28
Database-level Storage Analytics for Oracle Database 12c
-
08:20
Oracle SQL Tuning - Explain Plan Lies?
-
03:02
Oracle SQL Tuning with Foreign Key Constraints
-
01:53
SQL Tuning How to Tune Joins - Lesson 1
-
13:40
When to use Oracle Database Bitmap Indexes Lesson 2
-
14:05
Oracle Autonomous Database – Put Your Database on Autopilot
-
09:20
SQL Tuning with Oracle Database 12c Histograms
-
13:39
Oracle SQL Tuning - Oracle Execution Plans for Beginners
-
08:12
Oracle Database SQL Tuning with Direct and Indirect Reads
-
02:28
Oracle SQL Tuning with NOT NULL Constraints
-
04:13
SQL Tuning for Beginners Lesson 1 When and Why to Tune SQL
-
06:47
Running Oracle Database on Oracle Linux on Oracle x86
