oracle update query is taking lot of time..

From: Rajesh <>
Date: Thu, 2 Apr 2009 05:37:23 -0700 (PDT)
Message-ID: <>

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 Received on Thu Apr 02 2009 - 07:37:23 CDT

Original text of this message