InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 20:10:36 GMT20http://www.sqlservercentral.com/Forums/Topic1052626-146-1.aspxQuery, table definitions, index definitions and execution plan please.Tue, 18 Sep 2012 11:33:40 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1052626-146-1.aspxCheck if you have appropriate indexes.Tue, 18 Sep 2012 10:57:37 GMTjswong05http://www.sqlservercentral.com/Forums/Topic1052626-146-1.aspxAbout 75 percent of cost is being used by "Table Spool(Lazy Spool)" in the execution plan. The inputs on this operator are from an clustered index scan(cost is 0%) and a index seek(cost is 0%) from the same table with actual rows return 0 for each. I did do some research on lazy spool and seems like it is creating a temp table on temp db but why is the cost 75% when 0 records are fed as inputs?Mon, 24 Jan 2011 12:19:19 GMTcurious_sqldba