Search code examples
sql-execution-planexplainsinglestore

Is there any possibility to get explain plan results from stored procedures?

Explain plan, show plan and other commands are not allowed in stored procedures. I thought, I will call back from plancache (as per documentation said here), but there are no plans in there.

I am on cluster-in-a-box, with memsql 7.0.15.

Regards, cashy

Solution

  • from version memsql 7.1 EXPLAIN, PROFILE, and SHOW PROFILE are now allowed inside of stored procedures.