Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 16 Dec 2003 @ 18:44:31 GMT

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

Subj:   Re: Collect Stats on Single Column SI
From:   Arunachalam, Sankar

When you do it on column the stats go to TVFields and on index it goes to the indices. But it lets you do both even though the stats on the column is collected and is available it goes on to recollect on the index? May be because the stat-engine does that on the base table vs. the index sub table based on the command request. I wish Teradata get rid of this redundancy.

  <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: 28 Jun 2020