Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.
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.
memsql> DROP 123 FROM PLANCACHE; Query OK, 0 rows affected (0.00 sec)