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: Kalmact <kalmact_at_hotmail.com>
Date: 2 Sep 2003 01:52:18 -0700
Message-ID: <8007e332.0309020052.7239ee66@posting.google.com>


> No, you're correct. It's parent primary key updates that are the issue. But
> there are an awful lot of apps out there that take the easy way out: when
> you update column 3, the code issues says 'set column 1 to window 1, column
> 2 to window 2, column 3 to window 3...' and so on. Net result, you think
> you've updated something which isn't the primary key, but in fact you have.
> And the locking issues flow on from there.

A related question. The same thing would happen when we use 'update table set row= rowtype variable', isn't it? It may not be a big issue because of the way 9i handles it.

Cheers,
Kal

>
> But yes, I should have said 'update the parent table's primary key'.
>
> Regards
> HJR
Received on Tue Sep 02 2003 - 03:52:18 CDT

Original text of this message

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