Archives of the TeradataForum

Message Posted: Mon, 26 Sep 2005 @ 17:23:50 GMT

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

     RELEASE        V2R.05.01.02.06
     VERSION        05.01.02.16

I am re-running a test plan for Partitioned Primary Indices and came up with some interesting questions.

How do I know which partitions are active?

How do I know how much space each partition is using?

How do I know how many rows are in the partitions?

Obviously, I can query the actual table data against the partition definition to find out these answers, but I would think that I could get it from the data dictionary and/or the stats. My search of the database and documentation came up negative.

Am I missing something?

Thanks,

Glen

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