SQL Server Performance Forum – Threads Archive

Index spool

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 Thanks

---

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)

---

]]>