Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 07 Feb 2001 @ 01:18:07 GMT

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

Subj:   Re: Collect Stat
From:   Eric J. Kohut


In V2 R3, while you can submit a collect statistics on , I don't think it works like you've portrayed here. As I understand it (I could also be wrong) in V2 R3, when using the entire table option, the statistics are re-collected on each column or index that you had collected statistics on previously, but these are executed serially one at a time. So no time savings. This option is much easier.

In some release of V2 R4, I've heard that this will be done more efficiently but I don't know exactly when.

Eric J. Kohut
Senior Solutions Consultant - Teradata Solutions Group - Retail
Certified Teradata Master
NCR Corp.

  <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