This hint means that SQL Server will generate a new execution plan for each execution of a given query. Using the RECOMPILE hint is not for all queries, and you should be careful with it ...