Archives of the TeradataForum

Message Posted: Thu, 21 Jun 2012 @ 20:02:11 GMT

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

Hi,

Yes you can do merge join on a column that is subject to MVC. I suspect that if a column involved in a merge join is compressed then it will be uncompressed before being inserted into a spool file.

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

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