Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Parse overhead on Disabled constraints

Parse overhead on Disabled constraints

From: <MVallath_at_cs.com>
Date: Wed, 6 Sep 2000 22:45:01 EDT
Message-Id: <10611.116366@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US