0xC0000000. You'll never see these numbers unless you get the expl..." />
 
Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 18 Jun 2004 @ 23:04:46 GMT


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


Subj:   Re: About Spool Numbering
 
From:   Christie, Jon

As others have mentioned, spool numbers are assigned during the optimizer phase of the parser. There is nothing particularly significant about the numbering. They start at 1 and go up sequentially.

The spool numbers you see in an explain are LOGICAL spool numbers. When plastic steps are transformed into concrete steps, "real" spool numbers are assigned to replace the logical spool numbers. The real spool numbers are always > 0xC0000000. You'll never see these numbers unless you get the explain of a running request from PMON.

See my other responses for other tidbits...



     
  <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: 23 Jun 2019