← Back to team overview

maria-developers team mailing list archive

WL#182 New (by Mdcallag): Explain running statements

 

-----------------------------------------------------------------------
                              WORKLOG TASK
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
TASK...........: Explain running statements
CREATION DATE..: Sun, 13 Mar 2011, 09:44
SUPERVISOR.....: 
IMPLEMENTOR....: 
COPIES TO......: 
CATEGORY.......: Client-BackLog
TASK ID........: 182 (http://askmonty.org/worklog/?tid=182)
VERSION........: Benchmarks-3.0
STATUS.........: Un-Assigned
PRIORITY.......: 60
WORKED HOURS...: 0
ESTIMATE.......: 0 (hours remain)
ORIG. ESTIMATE.: 0

PROGRESS NOTES:



DESCRIPTION:

I want to know the query plan for running statements -- something like "SHOW PLAN 
FOR <connection_id>".  This requires running statements to generate a string that 
describes their plan in case another thread needs to examine it. For me it would 
be good enough to know the join order and indexes.


ESTIMATED WORK TIME

ESTIMATED COMPLETION DATE
-----------------------------------------------------------------------
WorkLog (v4.0.0)