Archives of the TeradataForum

Message Posted: Wed, 01 Dec 2004 @ 17:54:21 GMT

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

Hi,

Sometimes in the explain plan of some SQL we see ("1=1") condition when it is doing the product join. We do not see this condition in all product joins.

I will appreciate if somebody explains me in what circumstances optimizer uses ("1=1") condition?

Having this condition in the explain is bad?

thanks,

Akleema

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