Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 18 Dec 2003 @ 01:53:11 GMT

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

Subj:   Re: Collect Stats on Single Column SI
From:   Christie, Jon

Single column statistics go in DBC.TVFields regardless of whether the column has an index or not. Multiple column statistics go in DBC.Indexes even if there is no index on the columns. (We define a dummy index if there is none but don't build a secondary index subtable.) I am aware of no redundancty, but it would be an interesting thing to check into.

  <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: 23 Jun 2019