Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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

     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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016