Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 15 Jul 2003 @ 23:24:56 GMT


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


Subj:   Re: Collect stats on DBC.
 
From:   Chris Coffing

We have run the collect stats on DBC and made the error of running it on all columns.

You should not run collect stats on dbc.tvm... It doesn't like that and you will get wierd unwanted issues in the warehouse.

All the other tables seem to be OK. We saw some improvements for logins but not many other performance gains. We certainly didn't record any major findings. Don't know if it helps outside of the DBC.TVM issue...



     
  <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