Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 24 Jan 2008 @ 16:06:04 GMT


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


Subj:   Help (on Stats)
 
From:   David Clough

Obviously for Stats on a table I can use :

     HELP STATISTICS MyTable;

but I want to display the Stats for _only the Primary Index columns_. Now, I can do a loop from what comes back from the Stats for the table and then, for each column, establish whether it's in the appropriate DBC table, but if there's another really simple command then I'd rather have that - it would save me a lot of time.

Somehow, I get the feeling I'm going to have to do it the hard way.


Thanks,

Dave Clough
Database Designer
Express ICS

www.tnt.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