Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 08 Feb 2001 @ 08:08:37 GMT


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


Subj:   Re: Collect Stat
 
From:   Dieter N�th

Hi Dave,

  Although there has always been the command to re-collect stats at the table level, until V2R4, this has always been processed as a series of collect stats on each column and index. Each one is done serially, so there are no time savings by using this syntax.  


  With V2R4 (my understanding is that it is V2R4.0.0), re-collecting stats is done by a single scan of the table so this provides significant potential time savings.  



I just run an explain on collect stats on table level (V2R.04.00.01.13): still doing scans on each index subtable and several !! FTS on the base table for severel non-indexed columns...

So it's still doing it serially, but it's using access locks now.

kind regards

Dieter



     
  <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