RECOMPILE is useful for queries with variable values that vary widely each time they are compiled and executed.

• 对于变量值每次编译和执行时都广泛变化的查询,RECOMPILE很有用。