Archives of the TeradataForum
Message Posted: Thu, 20 Oct 2005 @ 09:23:41 GMT
<-- Anonymously Posted: Thursday, October 20, 2005 01:57 -->
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|