Archives of the TeradataForum

Message Posted: Thu, 29 Mar 2012 @ 12:43:09 GMT

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

Hi all,

In explain will generate "with residual condition" that means suppose we can take sql query i.e

     Select * from emp
     where emp_id=104
     and empname='allan';

In above statement two conditions involved which depend on each other. These scenario explain generate "with residual condition"

Regards,

Ramesh.

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