Archives of the TeradataForum

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

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

<-- 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>>