Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 11 Apr 2007 @ 13:52:22 GMT

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

Subj:   Re: Out of Spool after Collecting Statistics
From:   Thomas, Roland

What do the explains say? What changed after the collect statistics?

Sometimes the optimizer (being cost based) will chose to use more space so it can run faster.

Can't tell without the explains.

  <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