Archives of the TeradataForum

Message Posted: Thu, 20 Oct 2005 @ 09:23:41 GMT

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

<-- Anonymously Posted: Thursday, October 20, 2005 01:57 -->

Hi,

Please justify following behaviour in Teradata,

     1) select a.col1, a.col2, b.col3
        from   table1 a , ( select col3, col4 from table2 ) b
        where  a.col4 = b.col4 ;

Above statement gives spool space error.

     2) select a.col1, a.col2, b.col3
        from   table1 a , ( select col3, col4 from table2 group by 1,2) b
        where  a.col4 = b.col4 ;

Second query works fine and gives out put as per requirement. Only difference is group by.

Why spool space error is not generated in second case ??

Both tables contains huge data.

Thanks in advance.

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