Dropping an individual abstract plan

Use sp_drop_qplan to drop individual abstract plans. This example drops the specified plan:

sp_drop_qplan 588529130

A system administrator or database owner can drop any abstract plan in the database. Other users can drop only plans that they own.

To find abstract plan IDs, use sp_find_qplan to search for plans using a pattern from the query or plan, or use sp_help_qpgroup to list the plans in a group.