Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 21 Feb 2006 @ 23:50:29 GMT


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


Subj:   Re: A query on the PI properties of Teradata
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, February 21, 2006 17:12 -->

If one has to have a Primary Index access, then one has to specify equality conditions on all columns of primary index. The hash value is computed from all the columns of primary index.

In your specific case it does all-rows scan. If an index is defined on this column, we may have scope for that index access path.



     
  <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: 15 Jun 2023