RESULT_CACHE_MODE specifies when a
ResultCache operator is spliced into a query's execution plan.
ResultCache operator is added only when the query is annotated (that is, hints).
ResultCache operator is added to the root of all
SELECT statements (provided that it is valid to do so).
FORCE setting, if the statement contains a
NO_RESULT_CACHE hint, then the hint takes precedence over the parameter setting.