All Forums Database
jsergey 15 posts Joined 06/07
16 Jun 2009
Spool or CPU usage

Hi!Now I'm optimizing SQL queries and have a question - what is better: to decrease Spool Usage or to decrease CPU Usage(if they can not be decreased together) ?Some additional data:TotalCPUTime/SpoolUsage before optimization: 4.5/300MbTotalCPUTime/SpoolUsage after optimization: 9.00/1.5MbQueries are the same excepting some minimal changes.Thanks.Regards,Sergey

Adeel Chaudhry 773 posts Joined 04/08
16 Jun 2009

Hello,In my opinion, if this query is not to be executed at peak-times, lowering spool usage will lower the overall time considerably.But, it primarily depends on your preferences, usage and system load!HTH!Regards,Adeel

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.