Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Wed, 24 Jul 2002 @ 17:49:19 GMT


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


Subj:   Re: Problem with Search Condition in ON clause?
 
From:   Bourgoin, Gregory R

Michael,

  The explain shows that the optimizer converts the IN list to OR's in all cases I tried. Same results on V2R4.1 and Demo TNT V2R4.0  



Pretty standard stuff with the IN clause converted to ORs by the dbms engine. Does the same thing in SQL Server and DB2.


Have a good one,



     
  <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