DROP POOL
You remove a query pool from a resource plan by using this command.
DROP POOL syntax
DROP POOL plan_name.path
- plan_name.path
The resource plan name and hierarchy of query pool names, in dot notation
You cannot remove a default query pool or one that mappings point to.