Archives of the TeradataForum
Message Posted: Mon, 07 Dec 2015 @ 11:23:42 GMT
<-- Anonymously Posted: Monday, December 07, 2015 07:05 -->
In my project we have defined the Staging tables as NoPI tables. Data is loaded to these staging tables using Fastload via DataStage. Finally, data is moved from the staging tables to Base tables using simply bteq Insert/Select statements without any residual conditions or joins. Also all user queries run on the base tables.
In the light of above mentioned scenario is it useful in any way to collect stats on the Staging (NoPI) tables ? I think that in this case it will be futile to collect stats on the staging tables given that no conditions or joins are applied on them.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|