Help needed for SQL Tuning...

From: Titus <tolowok_at_gmail.com>
Date: 21 Jun 2006 08:52:38 -0700
Message-ID: <1150905158.705186.167130@b68g2000cwa.googlegroups.com>

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 - 10:52:38 CDT