Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!newsfeed.telusplanet.net!newsfeed2.telusplanet.net!newsfeed.telus.net!news-xfer.cox.net!peer02.cox.net!cox.net!news-server.columbus.rr.com!cyclone2.kc.rr.com!news2.kc.rr.com!twister.socal.rr.com.POSTED!53ab2750!not-for-mail
From: Richard Kuhler <noone@nowhere.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Update Problem
Lines: 43
References: <cc59b627.0312120749.2e5984d4@posting.google.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax)
X-Accept-Language: en-us, en
In-Reply-To: <cc59b627.0312120749.2e5984d4@posting.google.com>
Message-ID: <eMpCb.608$HL2.84@twister.socal.rr.com>
Date: Fri, 12 Dec 2003 20:43:54 GMT
NNTP-Posting-Host: 204.210.41.27
X-Complaints-To: abuse@rr.com
X-Trace: twister.socal.rr.com 1071261834 204.210.41.27 (Fri, 12 Dec 2003 12:43:54 PST)
NNTP-Posting-Date: Fri, 12 Dec 2003 12:43:54 PST
Organization: RoadRunner - West
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:250018

Mohammad wrote:

> Hi
> 
> I have this query to update some records in my table. It is working
> good but my problem is this query very slow. Is any way to do this job
> faster.
> 
> UPDATE SWKPIFA Y
> SET Y.SWKPIFA_TRAN_CODE  =  'G'
> WHERE SWKPIFA_START_TERM =  
>       ( SELECT MIN(X.SWKPIFA_START_TERM)
>           FROM SWKPIFA X
>          WHERE Y.SWKPIFA_PIDM = x.SWKPIFA_PIDM
>            AND Y.SWKPIFA_MAJR_CODE = X.SWKPIFA_MAJR_CODE)
>   AND SWKPIFA_END_TERM =  
>       ( SELECT MAX(X.SWKPIFA_END_TERM)
>           FROM SWKPIFA X
>          WHERE Y.SWKPIFA_PIDM = x.SWKPIFA_PIDM
>            AND Y.SWKPIFA_MAJR_CODE = X.SWKPIFA_MAJR_CODE)
> /

Depending on lots of information you haven't given us, you might try ...

UPDATE SWKPIFA
SET Y.SWKPIFA_TRAN_CODE  =  'G'
WHERE (SWKPIFA_PIDM,
   SWKPIFA_MAJR_CODE,
   SWKPIFA_START_TERM,
   SWKPIFA_END_TERM) IN (
     SELECT SWKPIFA_PIDM,
       SWKPIFA_MAJR_CODE,
       MIN(X.SWKPIFA_START_TERM),
       MAX(X.SWKPIFA_END_TERM)
     FROM SWKPIFA X
     GROUP BY SWKPIFA_PIDM,
       SWKPIFA_MAJR_CODE
     )
/

--
Richard Kuhler