RE: TKPROF output -- high current gets for INSERT

not for foreign key constratints ...
 
Lex.
 
----------------------------------------------------------------
Tom Kyte Seminar: http://www.naturaljoin.nl/events/seminars.html
----------------------------------------------------------------
 
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of stephen booth
Sent: Thursday, December 30, 2004 17:01
To: cary.millsap@xxxxxxxxxx
Cc: sat0789@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: TKPROF output -- high current gets for INSERT

On Thu, 30 Dec 2004 08:01:53 -0600, Cary Millsap <cary.millsap@xxxxxxxxxx>
wrote:
> Doesn't each RE constraint use an index?
> 
> Cary Millsap

I would have thought so.

Wouldn't making the indexes unusable implicitly disable the constraints?
Or, to put it another way, if the constraints are enabled doesn't that mean
that the indexes must be usable?

Or am I missing something?



--
http://www.freelists.org/webpage/oracle-l

Other related posts: