Forces a plan to be optimized and generated from scratch the next time it is run.

Syntax

DROP [plan_id | ALL] FROM PLANCACHE

Remarks

• plan_id - ID of the plan to invalidate. Find by running SHOW PLANCACHE.
• 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.

Example

memsql> DROP 123 FROM PLANCACHE;
Query OK, 0 rows affected (0.00 sec)

Related Topics

• Managing Plancache Memory Usage
• Understanding the Plancache

Was this Article Helpful?

Thanks For Your Feedback!