| Rollback segment issue [message #35709] |
Mon, 08 October 2001 11:24  |
k415
Messages: 2
Registered: October 2001
|
Junior Member |
|
|
Hi, Guys - I am trying to run an update statement on a table of 700,000+ rows, however, it is taking extremely long time to finish (over 1.5h). Is there any way to speed up the process since I am running it against production? could it be there is problem with rollback segment? Any input is greatly appreciated!!
Below is the update statement:
-------------------------------------
Update contacts
set partner_can_contact = 'y'
where partner_can_contact = 'n'
and user_id in
(select user_id
from contact_update)
---------------------------------
p.s. user_id is the primary key and index on both the contact and contact_update tables
-k
----------------------------------------------------------------------
|
|
|
|
| Re: Rollback segment issue [message #35712 is a reply to message #35709] |
Tue, 09 October 2001 05:33  |
Suresh Vemulapalli
Messages: 624
Registered: August 2000
|
Senior Member |
|
|
try this:
Update contacts a
set partner_can_contact = 'y'
where partner_can_contact = 'n'
and exists (select user_id
from contact_update b where a.user_id=b.user_id)
HTH
SURESH
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
