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)