Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 28 Mar 2002 @ 02:48:49 GMT

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

Subj:   Re: Collect Stats on large table
From:   Todd A. Walter

I'm afraid I no longer have a copy of the R3 documentation so I cannot match exactly. However, in the Collect Statistics Guidelines section of that book in 4.0 and 4.1 doc sets, that statement no longer exists.

You should always collect stats on NUSIs. The optimizer has little chance of properly using your indexes without stats.

For large tables with a UPI, it is not required to collect stats on the PI. This is the opposite of small tables where collecting on the PI helps us get good sizing information on the table (Small is defined as <1000 rows per amp).

  <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