Dropping an individual abstract plan

sp_drop_qplan drops 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 sp_help_qpgroup to list the plans in a group.