r.dragoi-1095738 (3/24/2010)
Maybe you are looking for something like this:SELECT TOP (10) *
FROM table
OPTION (HASH Join , recompile)
-- or just simple: OPTION (recompile)
What's the HASH JOIN hint for? There's no join.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi