Try creating an index on Date1. Then, rerun the update. Let me know
what happen!





Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Jeanine Blomberg is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: dgaikwad
[mailto:oracledba-ezmlmshield-x54511279.[Email address protected]
Sent: Sunday, October 07, 2007 11:58 PM
To: LazyDBA Discussion
Subject: Update Takes Lot Of Time

Hi DBAs

Following Update SQL takes more than 8 hours.

Update TABLE1
set Date1=Date2;



Date1 and Date2 are from same table TABLE1 and of DATE type.

Machine Config is P4 with 512 MB RAM no other big Processes are running.
TABLE1 is having 78 lakh records.


can any body tell me alternarte way to do this update.


Thanks & Regards,
Dinesh G.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

Oracle LazyDBA home page