Re: oracle update query is taking lot of time..
From: <gareth_at_jamms.org>
Date: Thu, 2 Apr 2009 05:46:41 -0700 (PDT)
Message-ID: <5f4f4ff8-1e88-40e6-9bdf-761347e06a13_at_e10g2000vbe.googlegroups.com>
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
Date: Thu, 2 Apr 2009 05:46:41 -0700 (PDT)
Message-ID: <5f4f4ff8-1e88-40e6-9bdf-761347e06a13_at_e10g2000vbe.googlegroups.com>
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 Received on Thu Apr 02 2009 - 07:46:41 CDT