This is an index to a series of posts I have been writing about optimization techniques that the Oracle database applies, or not, while adding constraints to tables:
- Part 1: Optimization of Check Constraint Creation
- Part 2: Optimization that Violates Data Integrity
- Part 3: Optimization of Foreign Key Constraint Creation
- Part 4: (Lack of) Optimization of Unique Constraint Creation
- Part 5: Adding a Column with a Default Value and a Constraint
- Part 6: Fast but Offline, or Online but Slow?
- Part 7: Adding a Unique Constraint in an Online Way
- Part 8: Constraint Optimization Summary
While writing this series I posted the following suggestions in the OTN Database Ideas section. If you also think they are good ideas, please vote up 🙂