MySQL Forums
Forum List  »  Optimizer & Parser

Intermediate Query Results
Posted by: Ashwini Singh
Date: September 12, 2014 08:37AM

Is it possible to access the intermediate results generated by mysql during execution of a query?? Creating a view for the query stores the results of the query, i need to store the intermediate results of the every query for further query optimization. I couldn't find any way out for this.

There is another point i want to extract. The candidate plans for which mysql finds the costs and selects the best plan.

I used the keyword "EXPLAIN", but it gives the execution plan that mysql has used to execute the query(considering its minimum cost), but the requirement is to find all the plans that mysql has considered before selecting the best one.

I know its a very broad question but i couldn't find anything in support of the task i want to do.

Options: ReplyQuote

Written By
Intermediate Query Results
September 12, 2014 08:37AM
September 13, 2014 09:23PM
September 15, 2014 05:42AM

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.