• Views don't have stored execution plans, because they're just saved SQL statements and are replaced by their definition early in the parsing phase of a query. They're not executed in their entirety like procedures or functions are.

    When you query a view, from inside a procedure or ad-hoc query, the resulting query is optimised and its plan stored depending on the normal rules of caching and reuse.

    p.s. All queries use an optimised execution plan, I think you mean 'cached execution plan'

    Auto update statistics has no effect whatsoever on how plans are cached in a database.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass