Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help needed for SQL Tuning...
On Wed, 21 Jun 2006 15:11:21 -0400, "Mark C. Stock" <mcstockX_at_Xenquery
.com> wrote:
>
>"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
>
Yes, they sure will be updated to NULL without the 2nd subquery.
-- Sybrand Bakker, Senior Oracle DBAReceived on Wed Jun 21 2006 - 16:03:24 CDT