Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 07 Jan 2011 @ 22:05:33 GMT

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

Subj:   Re: Tune the query - giving spool space error
From:   Mark Young

You could try using the following before running the query, it will point out any additional stats that might be needed to be completed.

Run 'diagnostic helpstats on for session;'

Then run explain

Look at the end of the explain for any recommended stats.

To turn off the diagnostic, just logoff the session.



  <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: 15 Jun 2023