Re: Help needed for SQL Tuning...

On 21 Jun 2006 08:52:38 -0700, "Titus" <tolowok_at_gmail.com> 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

Your posting is lacking the following information

• table definitions
• indices defined on those tables
• Oracle version
• Which optimizer you are using
• Whether statistics are current
• and above all: the execution plan of the affected statement.

Please do not expect any accurate answer when posting blindly without this information.

--
Sybrand Bakker, Senior Oracle DBA