Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: [SOLVED for good] performance tuning questions: replace IN (values)byJOIN
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.