Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 23 Nov 2002 @ 19:07:44 GMT


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


Subj:   Re: More Statistics Questions
 
From:   Belle, Patrick A

Stephen is correct if the query is covered by the index. The query will be serviced by a "full table scan" of the index sub-table in that case. However fully covering NUSI's have been the exception in the queries that I've seen.

Pat Belle
Teradata Certified Master



     
  <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