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.


  <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: 28 Jun 2020