Re: Help needed for SQL Tuning...

From: franck <francois.bourdages_at_harfan.com>
Date: 21 Jun 2006 11:44:18 -0700
Message-ID: <1150915458.634962.87690@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
Received on Wed Jun 21 2006 - 13:44:18 CDT