Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Parse overhead on Disabled constraints
What is the performance overhead (if any) on disabled constraints? My
assumption is that Oracle will have to validate if a constraint is available
and what the status is (ENABLED OR DISABLED). There should be a performance
impact, with having
constraints in ENABLED state
Vs having constraints in DISABLED state Vs No constraints or constraints dropped.
Any ideas or stats on this subject.
Thanks
Murali Vallath Received on Wed Sep 06 2000 - 21:45:01 CDT
![]() |
![]() |