Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 19 Jan 2005 @ 09:13:02 GMT


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


Subj:   Re: Are my Primary Indexes being used?
 
From:   Victor Sokovin

  Yes. I understand the PI function and how they work. I can see the fields that are being used with object logging but do not know if the Indexes are being used  



In many databases the analog of PI could be a structure separate from the table, and that's probably the background of the question. In TD, the PI is just a part of the table (the word "index" might be confusing if you come from the different). There is simply no other way for users to get to the data except via the PI. So, as far as I can see, there is no difference, in this context, between the "PI fields" and the "Indexes". If you believe that the former are "used" then the latter will be used as well.

Hope this helps.


Regards,

Victor



     
  <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