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.