Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020