Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 16 Nov 2011 @ 09:09:13 GMT


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


Subj:   Data about how an Index was used and the
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, November 16, 2011 03:34 -->

I'd like to know if there is a process in place of knowing if an index was used and how many times , for situations involving a join condition, where clause ?as against redistribution ( if it's a PI ) or ifs it's a Non PI ? who many times it was used in joins or in where clauses.

Another related? curiosity ? column indexstatistics is in an internal, Teradata privy, format and cannot normally be made sense of, unless you use VComp or TSET, best of my K. Any idea how this is done. It comes out as a .dat file using SQLA. So I am thinking, you should not need to connect to a host, when using these.



     
  <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