Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Sat, 16 Apr 2005 @ 16:13:20 GMT


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


Subj:   Re: Regarding the Spool Space during the EXPLAIN plan taken agianst SQL query
 
From:   PhilEdelsberg

The numbers are typically just assigned sequentially. I haven't seen any relationship between them.

The spool is just multiple work areas that get removed at the end of the operations.

No you can't look at them. If you need to look at intermediate results consider recoding your query and use volitile tables. You can run your query under Teradata Assistant and look at named Volatile tables.


Phil Edelsberg, CCP, PMP.



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020