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

Home -> Community -> Usenet -> c.d.o.server -> Re: [SOLVED for good] performance tuning questions: replace IN (values)byJOIN

Re: [SOLVED for good] performance tuning questions: replace IN (values)byJOIN

From: tojo <Tojo_at_hotmail.com>
Date: Mon, 1 Sep 2003 17:21:41 +0200
Message-ID: <MPG.19bd826de15deffa9896a3@news.t-online.de>


In article <3F536234.68EA4284_at_exxesolutions.com>, damorgan_at_exxesolutions.com says...
> >
> > correct me, if I'm wrong, but aren't we talking about the column in the
> > child table, which references the parent table?! I call this the foreign
> > key column; sorry if I was not precise enough;
> > that column in the child table does not automatically have an index,
> > only because it is defined as "...references father.xxx", but almost
> > always strongly needs one;
>
> Of course. I logged on while waiting for my coffee to brew. I should have
> realized you were referring to the child table.
>
> Oh well. Perhaps the question helped others who had already had their morning
> coffee or tea.
>

Hehe, yep. I'm in Europe so I'm several cups ahead of you guys.

Received on Mon Sep 01 2003 - 10:21:41 CDT

Original text of this message

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