0 - 2 of 2 tags for No More Spool Space issue

I have found that when I create a volatile table with say 200million rows where the primary index is explicitely stated and matches the first column in the table, I use much more spool space than if I just let Teradata defined the primary index.   Should, you define a primary index on a volatile table if the index is only on the first column in the temp t

Please tell why this issue is happening that I am getting error as NO MORE SPOOL SPACE when I try to run the SQL from table (UDW2BASE.PROV_NPI_TXNMY) and when I create a volatile table of the same then it is running successfully.
I am unable to figure out the cause for “No more spool space”.