 |
 |
Archives of the TeradataForum
Message Posted: Thu, 10 Jul 2003 @ 14:44:58 GMT
| Subj: | | Predicting the space needed for spool |
| |
| From: | | Jim Renner |
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.
| |
