RE: TKPROF output -- high current gets for INSERT

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Thu, 30 Dec 2004 17:50:13 +0100
Message-Id: <20041230165020.5219A458BFB@ha-smtp2.tiscali.nl>

not for foreign key constratints ...  

Lex.  

---

Tom Kyte Seminar: http://www.naturaljoin.nl/events/seminars.html

---

 

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of stephen booth
Sent: Thursday, December 30, 2004 17:01
To: cary.millsap_at_hotsos.com
Cc: sat0789_at_fastmail.fm; oracle-l_at_freelists.org Subject: Re: TKPROF output -- high current gets for INSERT

On Thu, 30 Dec 2004 08:01:53 -0600, Cary Millsap <cary.millsap_at_hotsos.com> 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

Received on Thu Dec 30 2004 - 10:48:53 CST