|
Archives of the TeradataForumMessage Posted: Tue, 30 Aug 2016 @ 08:54:45 GMT
<-- Anonymously Posted: Tuesday, August 30, 2016 12:14 --> Hi David, Greg, Thanks and appreciate your reply. Seems like, both the replies contradict. David: If the data is matching, then no need to run the stats (refresh stats) again. Greg: That is expected and the same function as "CREATE TABLE A AS TABLE B WITH NO DATA AND STATS;". The TABLE B stats are full inherited, both definition and values - they are not recollected. For that, you simply have to recollect on the target table. Can you please clarify?
| ||||||||||||||||||||||||||||||||||||||||||||||||
https: | ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 24 Jul 2020 | ||||||||||||||||||||||||||||||||||||||||||||||||