Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 09 Jul 1999 @ 18:00:55 GMT

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

Subj:   Re: Product and Merge Joins
From:   Hays McLean

Thanks for the responses. In these two queries, I know they are not logically equivalent, but I also know that the nested query would not contain any (or very few as to be meaningless) of the conditions that I am excluding. However, it seems to be good to add the (irrelevant) exclusions in order to get the optimizer to use a merge join method instead of a product join to save much time.

By experimenting, I have found that I can add a number of bogus exclusions to the nested query and apparently "trick" the optimizer into doing a merge join rather than a product join. This way the query results come in much, much faster. Is there any way besides this to force the system to use one join method over another?

Hays McLean
First American National Bank

  <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