insert or load ? best practices and performance
Hi every one. I would like to know the best practice for the problem I have:
I have a table that everyday has to be fully updated. I have a txt file with all rows to be imported. I would like to know somethings:
1 - before loading the txt file is better drop the table and create it again or a simple delete * from table will resolve ?
2 - to insert the rows into the table should I use the insert clause or use the command line to load the file ?
Subject
Views
Written By
Posted
insert or load ? best practices and performance
3589
September 16, 2010 01:19PM
1074
September 17, 2010 09:27AM
989
September 21, 2010 11:16AM
973
September 21, 2010 03:29PM
1016
September 17, 2010 06:37PM
960
September 20, 2010 06:44AM
902
September 20, 2010 10:43AM
1035
September 20, 2010 12:49PM
1091
September 20, 2010 06:28PM
976
September 21, 2010 06:52AM
942
September 21, 2010 11:07AM
945
September 22, 2010 12:14PM
1021
September 22, 2010 07:20PM
1048
September 23, 2010 08:17AM
885
September 23, 2010 09:27PM
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.