Archives of the TeradataForum

Message Posted: Thu, 25 Feb 2010 @ 09:15:49 GMT

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

<-- Anonymously Posted: Wednesday, February 24, 2010 23:31 -->

Hi,

Can any one help me out in understanding the below terminology of the EXPLAIN plan

"sliding-window merge join (contexts = 1, 16)"

What kind of join makes the above sense? Is it a SI-SI join or any other combination of index? How the performance will be with such a kind of join?

Thanks a lot in Advance.

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