Spool Space issue


Spool Space issue

Hello Guys,

We recently upgraded from 6.2 to 12 version. One of the queries which was running well in 6.2 has hit out with spool space issue.
As a first measure i have already collected stats . Still its failing.

So i would like to know in general what action should i take further?


Re: Spool Space issue

Check whether the number of AMPs are same in both of your TD versions. The spooling issue might happen with a single AMP running out of space if the table is not having proper Primary Index. Also check if the table you are using has grown more in the recent past. If nothing of them is true you have to only tune the query. You can probably create a volatile table to avoid this issue.