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