SQL Server Performance

Index spool

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by habesha, Feb 15, 2007.

  1. habesha New Member

    I called a function in my script and it is showing index spool.
    and taking some time to execute

    how can I optimize this index spool

  2. joechang New Member

    the execution plan does not show meaningful information for functions

    i think it may always show a spool no matter whats in the function
    so unless we know whats in the function, there is no advice that can be given (except get a faster CPU)

Share This Page