Archives of the TeradataForum
Message Posted: Mon, 07 Dec 2015 @ 11:23:42 GMT
Subj: | | Collecting Stats on NoPI Staging Tables |
|
From: | | Anomy Anom |
<-- 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
|