Abstract Plan Sharing Between Different Users

Enable abstract plan sharing between different users by using either the session wide option set plan shared, or the server wide option abstract plan sharing.

In previous releases, a separate entry was needed for each user ID executing a query using abstract plans.

The session wide syntax is:

set plan shared {on | off}

The server wide syntax is:

sp_configure "abstract plan sharing", 1

Note: Tables of a query using a shared abstract plan must be explicitly prefixed with the owner name or belong to the DBO user.