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

Full Oracle version and an Explain Plan will get you more help.

HTH -g Received on Thu Apr 02 2009 - 07:46:41 CDT