Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 18 Jun 2001 @ 15:03:46 GMT

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

Subj:   Re: Why redistributing?
From:   David Roth

Basically, the feedback I've received on collecting statistics was to do so for all indexes, with the possible exception of UPI's on very large tables.

My additional point here is that, yes, you definitely should collect statistics on the primary indexes of small tables regardless of index type (UPI or NUPI). This lets the optimizer know that the table is, in fact, a small table.



David W. Roth
Senior DW Consultant
Teradata Solutions Group

  <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