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.
Course Features
- Lectures 6
- Quiz 0
- Duration 50 hours
- Skill level All levels
- Language English
- Students 11
- Assessments Yes
