Questions tagged [table-spool]
The table-spool tag has no usage guidance.
2 questions
2
votes
1
answer
904
views
Adding 'top 20' massively slows down query!
I have a query:
select * from Aview where field=20
order by id desc
This returns 2700 rows from the view in about 1 second.
Adding 'top 20' to the query makes MSSQL return in 43 seconds!!
This has ...
- 173
0
votes
1
answer
2k
views
Unpredictable Slowness and Table Spool(Lazy Read)
I was testing on Stackoverflow database to find out possible cases wherein SQL Server doesn't recommend index in the execution plan however if we introduce one, it would help in great way!
Did it ...
- 3,904