A case of avoiding Eager spool

added by jacobsebastian
5/25/2011 1:40:46 AM

337 Views

"When I was looking the plan cache for the queries having “Table spool”, I came across this query.INSERT INTO @Result (OID,Partkey) SELECT OID, dbo.fgetPartKey(OID) FROM fn_getSplit( @P_OIDS,',' ) WHERE OID > 0 Query optimizer used the below plan to execute the above query. "


0 comments