Error!
Success!

A case of avoiding Eager spool

0
kicks

A case of avoiding Eager spool  (Unpublished)

"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. "


Kicked By:
Drop Kicked By: