Re: Help needed for SQL Tuning...

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 23 Jun 2006 10:12:48 +0100
Message-ID: <3vudnaEbQ64TLQbZnZ2dnUVZ8qCdnZ2d@bt.com>

Take a look at updatable join views - the mechanism may be appropriate for your example.

The following FAQ page is a starting point:

http://www.jlcomp.demon.co.uk/faq/joinview.html

-- 
Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html


"Titus" <tolowok_at_gmail.com> wrote in message 
news:1150905158.705186.167130_at_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 Fri Jun 23 2006 - 04:12:48 CDT