Archives of the TeradataForum
Message Posted: Mon, 17 May 1999 @ 18:45:54 GMT
The reason for this approach was due to the way Teradata used to execute drop table.
This function used to be very expensive. A delete was much faster. This is why the MSI tool used this approach. It would delete all from the table but leave the table definition to speed up the queries(without the drop on 5-100 tables / Report at 2-25 seconds / drop on a busy system.)
Now that we have Volitile temp tables we should look into using these as an approach to this problem.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|