db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4587) Add tools for improved analysis and understanding of query plans and execution statistics
Date Wed, 17 Mar 2010 14:56:27 GMT
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.


Mime
View raw message