Archives of the TeradataForum
Message Posted: Thu, 10 Jul 2003 @ 14:44:58 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|