Archives of the TeradataForum
Message Posted: Mon, 26 Sep 2005 @ 17:23:50 GMT
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?
|Copyright 2012 - All Rights Reserved|
|Last Modified: 21 Mar 2013|