insert..select speed
I'm running win2k with dual 2 ghz xeon processors and 2 gigs of ram.
I have a table with 1.5 million records in it with about 150 columns, I'm using the insert select syntax to do some de-duping between this table and another which has 1 column and about 16k records. I have to keep 1.5 million table complete as some data files need all the records and some I produce need those 16k records removed. Currently this process takes about 1-1.5 days to complete.
I am wondering is: Is this normal with this size of db and is there a better way that I could do it?
Subject
Views
Written By
Posted
insert..select speed
1845
March 29, 2005 04:08PM
1125
March 30, 2005 03:42PM
1175
March 30, 2005 07:30PM
1361
December 11, 2005 03:46PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.