Archives of the TeradataForum

Message Posted: Wed, 01 Dec 2004 @ 21:05:35 GMT

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

There is one very useful condition where you will see the "1=1" within the explain. That's when the optimizer has decided to utilize Large Table/Small Table join optimization. This is where the optimizer has decided to do a Cartesian product of two or more small tables in order to "generate" the Primary Index values for the larger table.

Robert Meunier

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