![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Tue, 22 Sep 2009 @ 11:39:02 GMT
Subj: | | Re: Update of millions of records |
|
From: | | Victor Sokovin |
| Create tableB as tableA with data and statistics, | |
I checked the archives and it would appear that we have not yet discussed this on the Forum. In the documentation, the statement comes with a
few pages of warnings and restrictions, which probably means that the scope of its usage is still testing environments.
Also, I understand that copying stats using this method is only possible if we copy the data at the same time. Moreover, all the rows in the
table, or, else, the cardinalities of source and target tables would differ and copying of the stats in such cases would not work. Not the most
economic way of doing this if data will have to be deleted afterwards.
Victor
| |