Oracle Database SQL Tuning with Constraints
Duration: 50 hours
Free
Learn how to tune SQL – especially in a data warehouse – 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.
-
Tutorial Lessons