Re: oracle update query is taking lot of time..
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Fri, 03 Apr 2009 09:08:37 -0500
Message-ID: <IMoBl.11388$jZ1.11299_at_flpi144.ffdc.sbc.com>
Rajesh wrote:
> On Apr 2, 5:46 pm, gar..._at_jamms.org wrote:
>
>
> ORACLE Version i am using is:
>
> SQL*Plus: Release 9.2.0.1.0 - Production on Fri Apr 3 14:28:30 2009
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.1.0 - Production
Date: Fri, 03 Apr 2009 09:08:37 -0500
Message-ID: <IMoBl.11388$jZ1.11299_at_flpi144.ffdc.sbc.com>
Rajesh wrote:
> On Apr 2, 5:46 pm, gar..._at_jamms.org wrote:
>> On 2 Apr, 13:37, Rajesh <mrajesh1..._at_gmail.com> wrote: >> >> >> >> >> >>> Dear Experts, >>> I have a very huge table having 89 columns and 100,00,000(1CRORE) >>> records. >>> update customers_master set status='R' >>> where REC_ID in >>> ( select REC_ID from customers_master where >>> ( >>> (firstname is null and >>> lastname is null) or >>> address1 is null or >>> mobilenumber is null >>> ) >>> and batchnumber='1'); >>> basically we are marking customer record as "R" if any of the above >>> listed fields(in the query) are blank. >>> can we use PARTITION BY option in query to optimize it. >>> thanks in advance >> Full Oracle version and an Explain Plan will get you more help. >> >> HTH >> >> -g- Hide quoted text - >> >> - Show quoted text -
>
>
> ORACLE Version i am using is:
>
> SQL*Plus: Release 9.2.0.1.0 - Production on Fri Apr 3 14:28:30 2009
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.1.0 - Production
Hmmm.. another NON-Supportable database running someones production. You do realize there is absolutely NO support for this environment - right? Received on Fri Apr 03 2009 - 09:08:37 CDT