abstract plan sharing

abstract plan sharing enables abstract plan sharing between different users.

Summary Information

Default value 0 (off)
Valid values 0 (off), 1 (on)
Status Dynamic
Display level Comprehensive
Required role System administrator
Configuration group SQL Server Administration

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