Thursday, April 14, 2011

Constraints : FKs influence in performance , Deferrable Decleration

Very useful articles about constrains from Tom Kyte. About Fks and the affect on Query Optimizer. http://www.oracle.com/technetwork/issue-archive/2009/09-may/o39asktom-096149.html About the deferrable status and suggestion when to implement it. (First Part of the Article) http://www.oracle.com/technetwork/issue-archive/2011/11-may/o31asktom-354139.html