Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 06 Feb 2004 @ 16:49:06 GMT


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


Subj:   Re: A weird and unusual circumstance...
 
From:   Frank C. Martinez IV

Well, yes, Query 1 and 3 are very different. But #2 is actually an example of other queries that we've run on the same table. It still comes out to be the same explain. What I question is why the one query is trying to "traverse the index" when all it has to do is sample in the same manner as one of the other columns. It's yucky, that's what.


iv



     
  <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