Stored Procedures Execution Plan
Posted by: Ismael Jebril
Date: February 09, 2018 06:04AM

Hi all,
I've been trying to find the way of seeing the execution plan of a stored procedure through MySQL Workbench and I was not able to do it.
I'm proccessing large XML files inside the procedures (with ExtracValue function) and I would like to see what's going on inside the procedure because it takes a long time to run.
If anybody knows any way to see what is happening inside my procedure, the run times of every call to the ExtractValue, I willl be greatful.

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Stored Procedures Execution Plan
117
February 09, 2018 06:04AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.