Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 22 May 2012 @ 10:11:11 GMT


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


Subj:   IN Vs = [Equality]
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, May 22, 2012 03:45 -->

Hello Experts,

I have encountered that my end users run many queries with few IN clauses which has only one value in it. Can any one share your experise on this if this is really a perf issue all together?

Ex:

     Sel colA,colB,colC from xyz where Emp_Desig IN('mng');


     
  <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