Go to http://www.teradataforum.com/attach.htm and download my stats query to extract that info for all existing stats using a single request :-)
Partition stare stored in dbc.indexes with an IndexType of 'D'.
My query should return that info, too. You should check if you're using the latest version from the link above.
Currently i'm enhancing it (including using SQL UDFs in TD13.10) and i'll post a blog or article on it when i'm finished :-)
Dieter, this is great!!!
I have a small variation, and not sure if your query can be modfied to get the info.
I am looking for Rowcount in each partition for a table. Rather the total row count of a table, is it possible to get the row count for each partiiton for an object.
of course the technique to extract those float values could be extended to retrieve row counts for partitions (i did something similar for dates once).
But his would only be possible if the number of partitions is less than approx. 400, as the number of intervals is limited.
Thank you Dieter. 400 is good enough, I am looking for some pointers not the exact replica of actual table. So let me play around and see what I find.