Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023