Открываем books online... :)

Misha v.3 27.05.2002 14:47

Books online:
Nested Loops (77%):
Advanced Query Tuning Concepts | Understanding Nested Loops Joins:
"...In large queries, however, nested loops joins are often not the optimal choice."


Table Spool (9%):
Analyzing a Query | Logical and Physical Operators:
The Table Spool physical operator scans the input and places a copy of each row in a hidden spool table (stored in the tempdb database and existing only for the lifetime of the query).


Index Spool (7%) - опять tempdb...

В общем я бы пооптимизировал этот запрос :)))
Хотя если начальник сказал... :)

---