Oracle Database SQL Tuning with Constraints
Duration: 50 hours
If you are a student of an accredited academic institution call us for a 25% discount.
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.