Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 31 Jul 2012 @ 13:13:02 GMT

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

Subj:   Re: Automatic Script to collect stats on index and defined columns
From:   Gregg, William

Hi -- perhaps the biggest advantage of naming all indices is that statistics collection may be done by referencing the name of the index rather than citing all the columns in the statement.

If your indices are not named, consider doing so. A naming standard using a suffix of_x01, _x02, _x03, etc. for the Idxs will work well.


Bill Gregg

  <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