• If option recompile is used the plan doesn't remain in cache so it won't lead to cache bloat. Disclaimer, don't run this in production.

    dbcc freeproccache

    go

    select * from msdb.dbo.sysjobs option (recompile)

    go

    select * from sys.dm_exec_cached_plans cp

    cross apply sys.dm_exec_sql_text(cp.plan_handle) st

    where st.text like '%sysjobs%' option (recompile)

    go

    select * from msdb.dbo.sysjobs

    go

    select * from sys.dm_exec_cached_plans cp

    cross apply sys.dm_exec_sql_text(cp.plan_handle) st

    where st.text like '%sysjobs%' option (recompile)

    go

    While looking into this I found that the recompiled statement didn't exist in sys.dm_exec_query_stats either which has performance troubleshooting implications.