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

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

Re: Parse overhead on Disabled constraints

From: <mvallath_at_cs.com>
Date: Thu, 07 Sep 2000 11:58:12 -0400
Message-Id: <10612.116418@fatcity.com>


I was not clear enough, I agree about indexes and the foreign key requirements etc. I was more concerned about the check and not null constraints.

ORACLE-L_at_fatcity.com wrote:
>
> Hi, instead of talking about the performace overhead caused by enabled constraints i want to give you a simple example describing a worst scenario :
>
> Suppose to have a table A with a foreign Key on the field a1 pointing to the field b1 of table B
>
> Suppose to delete N record from the table B
> If the field a1 wasn't indexed you would wait for N full table scans on A
>
> Hope this helps
> Davide
>
> -----Original Message-----
> Sent:    Wed, 06 Sep 2000 21:20:28 -0800
> To:      ORACLE-L_at_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
>
>
>
>
> --
> Author:
>   INET: MVallath_at_cs.com
>
> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California        -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>
>
> ___________________________________________________________________________
> Visit http://www.visto.com/info, your free web-based communications center.
> Visto.com. Life on the Dot.
>
> --
> Author: Davide Bellesi
>   INET: davide.bellesi_at_visto.com
>
> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California        -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
Received on Thu Sep 07 2000 - 10:58:12 CDT

Original text of this message

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