 |
 |
Archives of the TeradataForum
Message Posted: Mon, 05 Sep 2005 @ 13:53:38 GMT
| Subj: | | Re: Less spoolspace and performance |
| |
| From: | | Victor Sokovin |
| | may I know if I have less spool space then SQL will perform slow | |
When you decrease the spool space there is a higher risk of queries failing rather than slowing down. If the system hits the spool space limit
for the given user, it does not attempt to put the query to a queue and wait until the space becomes available, nor does it use any slow paging or
something like that. The first "unlucky" query just fails.
Regards,
Victor
| |
