Archives of the TeradataForum

Message Posted: Thu, 06 Nov 2003 @ 22:49:26 GMT

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

Ivan,

30% freespace for spool is a pretty good rule of thumb. If you expect a high level of concurrency for very large table full table scans, you might want to compare that number to the level of concurrency * the size of the largest table and take the larger of the two. For most implementations, these two estimates are remarkably close.

Pat Belle
Certified Master

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