Archives of the TeradataForum

Message Posted: Fri, 28 Aug 2009 @ 10:19:51 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi All,

I was running two queries

     Select * from table1;

     Select top 10* from table 1;

I got the error with spool space. I am wondering if I select top 10*, why so much spool space needed.

I am not running any other query using my id.

Could anyone please clarify why this happens?

Thanks,

Prasad

	<Prev	Next>		<<First	<Prev	Next>	Last>>