Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 30 Apr 2004 @ 12:40:59 GMT


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


Subj:   Re: Information on COVER INDEX and query optimization...
 
From:   Raghav Vaidya

Prabhjot,

A SI is said to be covered when your query selects only those columns that are defined on the SI. That way only SI sub-table row is read and the request satisfied withput reading the base table table row.

The explaination is somewhere in one of the manuals that discusses all the INDEX choices.


Hope that helps

Raghav



     
  <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: 23 Jun 2019