Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help needed for SQL Tuning...
"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 Received on Wed Jun 21 2006 - 14:11:21 CDT