Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 09 Jun 2004 @ 10:00:51 GMT

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

Subj:   Re: About Spool Numbering
From:   Sanjaya Nagabhushan


This is a very high level understanding. Teradata optimizer explores all the possible ways it can do a query. During this process, Spool files are numbered in the order in which it considers all the possibilities. Finally it selects one plan which has the least cost. Due to this the spool file numbers will not necessarily be in sequence. If I am correct, The current limit on number of spool files must be 2048.


  <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