Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Partitioned Primary Indices - Is there a way to see
From:   Glen Blood

     RELEASE        V2R.

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?



  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020