You are viewing an older version of this section. View current production version.
DROP ... FROM PLANCACHE
Forces a plan to be optimized and generated from scratch the next time it is run.
DROP [plan_id | ALL] FROM PLANCACHE
plan_id- ID of the plan to invalidate. Find by running
ALL- Drop all plans currently in memory. Note that plans on disk but not in memory are unaffected.
- This command will only drop plans stored on the node where it is run.
- Dropping plan cache entries on an aggregator node will not drop the corresponding leaf-only plans from the leaf plan caches.
memsql> DROP 123 FROM PLANCACHE; Query OK, 0 rows affected (0.00 sec)