Archives of the TeradataForum
Message Posted: Fri, 15 Apr 2005 @ 14:59:10 GMT
When I take a Explain Plan against any query which has more number of joins, there are some SPOOL space used for intermediate operations.
For eg: Spool-1, Spool-2 and Spool-7. How are these related and can I view the data's in the intermediate Spools after every operations.
Can anybody expalin about the Spool along with its number.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|