We have some data warehouse applications and some tables which are not indexed etc , in such cases we use it.

In my own query I had a few more tables, but it can used just like I said OPTION (Recompile)

Maybe you are looking for something like this:

SELECT TOP (10) *

FROM table

OPTION (HASH Join , recompile)

-- or just simple: OPTION (recompile)