Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 04 Mar 2002 @ 08:46:02 GMT


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


Subj:   Re: COLLECT STATISTICS on DBC
 
From:   David Wellman

Petr,

I don't think there are any technical reasons why you couldn't do this -- although you may need to stay away from the non-hashed tables. I also can't think of a reason why you shouldn't. These tables are 'just' database tables that are involved in queries which have to be optimised, and collected statistics are one way of helping the optimiser to get the best join/access plan.

The optimiser does have some hooks/special processing for some system tables but the stuff that I'm aware of is mainly to do with automatically setting an access lock on tables etc. I suppose it is possible that the optimiser will ignore stats on system tables (although I doubt it) -- only trial and error or someone from ncr can confirm that.

I'm guessing that you're mainly thinking of the frequently accessed tables -- tvm, dbase, resusage???? etc etc -- and I can't see any reason why you shouldn't collect stats on these.


Cheers,

Dave

Ward Analytics Ltd: Information in motion (www.ward-analytics.com)



     
  <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: 27 Dec 2016