Re: Help needed for SQL Tuning...

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 21 Jun 2006 15:11:21 -0400
Message-ID: <v6qdnQz4x-xCBATZnZ2dnUVZ_qKdnZ2d@comcast.com>

"franck" <francois.bourdages_at_harfan.com> wrote in message news:1150915458.634962.87690_at_u72g2000cwu.googlegroups.com...
: Your "and exists" part is not needed here. Because you have already the
: same filter in your sub select.
:
: for the rest... waiting..
:
:
: Titus wrote:
: > Hello folks,
: >
: > Can someone assist in better tuning this query?
: > It is taking over 45mins to complete the update.
: >
: > UPDATE supp_sec_tbl a
: > SET a.descr =
: > (SELECT b.descr
: > FROM defn_tbl b
: > WHERE b.rollcol = a.rollcol)
: > WHERE a.dbase = :b1
: > AND EXISTS (
: > SELECT c.rollcol
: > FROM defn_tbl c
: > WHERE a.rollcol = c.rollcol);
: >
: >
: > Titus
:

actually, i believe it is necessary, otherwise rows that do not have a corresponding DEFN_TBL entry will get updated to a null description

++ mcs Received on Wed Jun 21 2006 - 14:11:21 CDT