Lazy Spool - How can i improve/avoid this?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Lazy Spool - How can i improve/avoid this?

Lazy Spool - How can i improve/avoid this?

Rate Topic

Display Mode

Topic Options

Author

Message

curious_sqldba

Posted Monday, January 24, 2011 12:19 PM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:30 PM
Points: 1,169, Visits: 2,682

About 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?

Post #1052626

jswong05

Posted Tuesday, September 18, 2012 10:57 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, March 18, 2013 7:54 AM
Points: 27, Visits: 421

Check if you have appropriate indexes.

Jason
http://dbace.us
Tongue

Post #1360899

GilaMonster

Posted Tuesday, September 18, 2012 11:33 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 12:59 PM
Points: 37,640, Visits: 29,895

Query, table definitions, index definitions and execution plan please.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1360919

« Prev Topic | Next Topic »

Permissions