Add tools for improved analysis and understanding of query plans and execution
statistics
-----------------------------------------------------------------------------------------
Key: DERBY-4587
URL: https://issues.apache.org/jira/browse/DERBY-4587
Project: Derby
Issue Type: Improvement
Components: SQL, Tools
Reporter: Bryan Pendleton
Assignee: Bryan Pendleton
I think it would be great to see some work in the area of tools for helping
with the analysis of complex query execution. Quite frequently, users of
Derby have trouble comprehending (a) how their query is being translated
into a query plan by the optimizer, and (b) what the execution-time resource
usage of the various parts of the query is.
There are low-level features in Derby which capture this information and
record it, such as logQueryPlan, and the XPLAIN tables, but there is a lot
of opportunity for designing higher-level tools which can process the query
plan and execution statistics information and present it in a more
comprehensible fashion.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
