[DERBY-4587] Add tools for improved analysis and understanding of query plans and execution statistics

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 10.7.1.1
• Component/s: SQL, Tools
• Labels: gsoc gsoc2010 mentor
• Assignee: Nirmal Fernando
• Reporter: Bryan Pendleton
• Created: 17/Mar/10 14:54
• Updated: 17/Jun/13 09:19
• Resolved: 15/Nov/10 12:25

Description

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.

Issue Links

• incorporates: DERBY-4766 Redesign the PlanExporter tool API for simplicity
• incorporates: DERBY-4768 Create template style sheets for PlanExporter tool and copy those templates into demo/templates as part of building a release
• incorporates: DERBY-4775 Allow exporting of multiple query plans in a single operation of PlanExporter Tool
• incorporates: DERBY-4783 Add all data in XPlain tables into the XML file generated by PlanExporter Tool
• is depended upon by: DERBY-4758 Adding documentation about the PlanExporter Tool
• is related to: DERBY-4902 Encoding problem in output from plan exporter

Sub-Tasks

• Adding documentation about the PlanExporter Tool: Closed
• Investigate character set and encoding issues of PlanExporter Tool: Closed