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) by JOIN

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

From: mitt <nospam_at_nospam.at>
Date: Mon, 01 Sep 2003 13:53:53 +0200
Message-ID: <3F533351.9030500@nospam.at>


tojo wrote:
> In article <3f5315cd$0$10359$afc38c87_at_news.optusnet.com.au>,
> howardjr2000_at_yahoo.com.au says...
>
> isn't there only a locking issue if you update the primary key of the
> parent table? Updating other fields should be OK. Please correct me if
> I'm wrong.

and the same is true for deletes of parent-rows and inserts of child-rows,...
the situations in which it is not necessary to have an index on a foreign key are so rare in real life, it easiest not to think much and just create one! Received on Mon Sep 01 2003 - 06:53:53 CDT

Original text of this message

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