Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 16 Sep 2002 @ 19:57:21 GMT


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


Subj:   Re: optimiser query
 
From:   Kumaran Anantaraman

I am currently facing same issue : 2 queries that are only different in the order of the table names in the FROM clause produce different plans, in fact 1 has a product join of 1=1. Subject to the explanation given above by Hough, is there a guideline on preferred order of table? Is it better to list small tables first, or good selectivity tables first? I am also going to explore collect stats to help optimizer break the tie.

Thanks.



     
  <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