Archives of the TeradataForum

Message Posted: Thu, 10 Jul 2003 @ 14:44:58 GMT

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

I have a collegue who is having issues with the population of a very large table. Seems his spool space is blowing up. I have made the suggestions that his data might be skewed, and joining on primary indexes and such, however his initial question whas how to calculate the amount of space they need for a set query.

So, Any suggestions?

I am thinking there has got to be something with row-count, index type, join columns, and data type that would work.

Thank you for your assistance.

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