what is more efficient?

General
Enthusiast

what is more efficient?

hello, I would like to understand what is more efficient doing a

drop table,
reload using Fastload
collecting Stats

or

delete all records in table
Insert into
collect stats

this is a monthly process, between 5 - 7 million rcds, with primary index. this is important for me to know how Teradata handles one method versus the other
4 REPLIES
Enthusiast

Re: what is more efficient?

Fastload is the fastest way of loading data into a table, if you have a data file.
However, if you are loading table to table insert into makes much sense.
Junior Supporter

Re: what is more efficient?

...
or

delete all records in table
load using Fastload
collecting Stats

or
delete all records with multiload task
load using Fastload
collecting Stats

HTH.

Cheers.

Carlos.

Re: what is more efficient?

5-7 million records.. good.. but how wide is the table? Also what is the OS ? Is it *nix or MVS ? And primary index is unique or non-unique? and finally where is the data for the new insert coming from ? Tape / Disk / File / result of DML from within Teradata ?

All these factors impact a solution.. and also the vprocs you have too..
Enthusiast

Re: what is more efficient?

folks, thank you all for your responses.. I have made the necessary chnages to the procedures and they are working well.. we are using FastLoad.