oracle update query is taking lot of time..
Date: Thu, 2 Apr 2009 05:37:23 -0700 (PDT)
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
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