Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 25 Aug 2009 @ 16:06:14 GMT


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


Subj:   Re: Parsing of SQL in teradata
 
From:   Darapureddy, Sudheer

Hi,

Below is the answer from the Teradata support for a similar question we had at our site.

In TD.12, the order of evaluation of the filter conditions is chosen by the optimizer based on selectivity of the condition. (i.e. the condition which is capable of filtering more number of rows).

If the selectivity is same for both the filter conditions, then we can not guarantee the order of evaluation of the filter condition.


Thanks,

Sudheer.



     
  <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