You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

DROP ... FROM PLANCACHE

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