Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 16 Apr 2009 @ 13:12:03 GMT

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

Subj:   Re: Collecting Stats - Column or Index
From:   Fred W Pluebell

The same stats are always stored in the same place, regardless of whether the COLLECT STATS says INDEX or COLUMN - assuming the index exists at the time you do the COLLECT (so the INDEX form is valid).

The only real difference is in a fairly unusual situation. If you first collected stats on a list of COLUMNS for which there was no corresponding index, then subsequently created such an index, you must either continue to use the COLUMNS form or explicitly DROP the non-indexed COLUMN stats. The INDEX form doesn't allow you to update the non-indexed (IndexType 'M') rows in DBC.Indexes.

  <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