Archives of the TeradataForum

Message Posted: Fri, 28 Oct 2005 @ 12:59:21 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Friday, October 28, 2005 07:45 -->

Some directions that I typically follow:

1) Insert/Select X Fexp/Fastload -> means that you are creating a new table from another one existing. In this case, as there is no lines in the new table, no time would be spent in a rollback operation. If you have available space to create a new copy of a table, I would opt to use an Insert/Select, no doubt;

2) Insert/Select X Fexp/Multiload -> means that you are populating a table that already have data. In this case I would look to the solution with care. Normally in this case I consider the number of lines involved. 10,000 lines, I would opt to Insert/Select. 100,000-300.000 lines, I would consider Insert/Select, depending on the speed of my system and keeping in mind that a rollback could take 3 times the time spent to insert the rows, to do the rollback.

Said that, I would like to finish saying that the main criteria I use to take my decision is the rollback time. Teradata is a very stable system and rarely I faced situations where a transaction with Insert/Select had problems and a rollback started. But, you can not forget to consider this possibility.

Good luck!

	<Prev	Next>		<<First	<Prev	Next>	Last>>