Archives of the TeradataForum

Message Posted: Mon, 07 Dec 2015 @ 11:23:42 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Monday, December 07, 2015 07:05 -->

Hi,

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.

Thanks

	<Prev	Next>		<<First	<Prev	Next>	Last>>