Archives of the TeradataForum
Message Posted: Thu, 24 Jan 2008 @ 16:06:04 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|