Archives of the TeradataForum

Message Posted: Tue, 17 Aug 2010 @ 17:08:54 GMT

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

I think Frank is right and stats are important. One thing I learned a while ago was using a PRODUCT join (or CROSS JOIN to be more specific in the Syntax) to apply a one row table or data set to all the rows in a large table so that I can then use CASE logic efficiently, do calculations, etc. Usually these are some metrics, dates, or what ever. Using a CROSS JOIN is VERY fast and efficient in this case. So PRODUCT joins can also be your 'Friend'!

For what it's worth on today's market;-)

JK

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