Derby
  1. Derby
  2. DERBY-4587

Add tools for improved analysis and understanding of query plans and execution statistics

    Details

      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.

      1. DERBY-4587-tool-9.12.diff
        16 kB
        Nirmal Fernando
      2. DERBY-4587-tool-9.12.diff
        4 kB
        Nirmal Fernando
      3. DERBY-4587-tool-9.12.diff
        4 kB
        Nirmal Fernando
      4. DERBY-4587-tool-9.11-license_header_inXSL.diff
        3 kB
        Nirmal Fernando
      5. DERBY-4587-tool-9.10-eol_style_native.diff
        2 kB
        Kristian Waagan
      6. DERBY-4587-tool-9.9-formatting.diff
        84 kB
        Kristian Waagan
      7. DERBY-4587-tool-9.8-modified.diff
        33 kB
        Kristian Waagan
      8. DERBY-4587-tool-9.8.diff
        34 kB
        Nirmal Fernando
      9. DERBY-4587-javadoc_fix.diff
        0.3 kB
        Nirmal Fernando
      10. DERBY-4587-tool-9.7.diff
        82 kB
        Nirmal Fernando
      11. DERBY-4587-tool-9.7.diff
        81 kB
        Nirmal Fernando
      12. advancedViewXSL2.xsl
        4 kB
        Nirmal Fernando
      13. advancedViewXSL.xsl
        4 kB
        Nirmal Fernando
      14. AdavancedXSL-mouseover.jpg
        86 kB
        Nirmal Fernando
      15. advancedViewXSL.xsl
        4 kB
        Nirmal Fernando
      16. advancedXSL-3.jpg
        138 kB
        Nirmal Fernando
      17. advancedXSL-2.jpg
        118 kB
        Nirmal Fernando
      18. advancedXSL-1.jpg
        65 kB
        Nirmal Fernando
      19. DERBY-4587-tool-9.6.diff
        68 kB
        Nirmal Fernando
      20. DERBY-4587-tool-9.5.diff
        67 kB
        Nirmal Fernando
      21. derby-logo.png
        4 kB
        Nirmal Fernando
      22. vanilla_html.xsl
        2 kB
        Nirmal Fernando
      23. DERBY-4587-tool-9.4.diff
        82 kB
        Nirmal Fernando
      24. DERBY-4587-tool-9.3.diff
        78 kB
        Nirmal Fernando
      25. DERBY-4587-tool-9.2.diff
        72 kB
        Nirmal Fernando
      26. DERBY-4587-tool-9.1.diff
        72 kB
        Nirmal Fernando
      27. DERBY-4587-tool-9.diff
        73 kB
        Nirmal Fernando
      28. xml_doc_screenshot.jpg
        118 kB
        Nirmal Fernando
      29. vanilla_html.xsl
        2 kB
        Nirmal Fernando
      30. DERBY-4587-tool-8.diff
        25 kB
        Nirmal Fernando
      31. basic_html-4.2.jpg
        74 kB
        Nirmal Fernando
      32. basic_html-4.1.jpg
        81 kB
        Nirmal Fernando
      33. basic_html-2.3.jpg
        73 kB
        Nirmal Fernando
      34. vanilla_html.xsl
        2 kB
        Nirmal Fernando
      35. DERBY-4587-tool-test2.diff
        3 kB
        Nirmal Fernando
      36. DERBY-4587-tool-7-b.diff
        19 kB
        Nirmal Fernando
      37. basic_html-3.jpg
        93 kB
        Nirmal Fernando
      38. basic_html-2.2.jpg
        90 kB
        Nirmal Fernando
      39. vanilla_html.xsl
        2 kB
        Nirmal Fernando
      40. DERBY-4587-tool-7.diff
        18 kB
        Nirmal Fernando
      41. basic_html-2.jpg
        75 kB
        Nirmal Fernando
      42. DERBY-4587-tool-test1.diff
        3 kB
        Nirmal Fernando
      43. DERBY-4587-tool-6.diff
        17 kB
        Nirmal Fernando
      44. xml_doc_screenshot.jpg
        111 kB
        Nirmal Fernando
      45. vanilla_html.xsl
        2 kB
        Nirmal Fernando
      46. Simple HTML View (Pure XSL).jpg
        91 kB
        Nirmal Fernando
      47. DERBY-4587-tool-5.diff
        17 kB
        Nirmal Fernando
      48. screenshot-3.jpg
        149 kB
        Nirmal Fernando
      49. test.xml
        1 kB
        Nirmal Fernando
      50. test4.xsl
        3 kB
        Nirmal Fernando
      51. screenshot-2.jpg
        149 kB
        Nirmal Fernando
      52. screenshot-1.jpg
        165 kB
        Nirmal Fernando
      53. DERBY-4587-tool-4.diff
        16 kB
        Nirmal Fernando
      54. DERBY-4587-tool-3.diff
        9 kB
        Nirmal Fernando
      55. DERBY-4587-tool-2.diff
        9 kB
        Nirmal Fernando
      56. DERBY-4587-tool.diff
        9 kB
        Nirmal Fernando
      57. Derby Query Plan Screen Shot 2.jpg
        117 kB
        Nirmal Fernando
      58. Derby_Query_Plan_Screen_Shot.jpg
        20 kB
        Nirmal Fernando
      59. Source.rar
        5 kB
        Nirmal Fernando
      60. Read_Me.txt
        1 kB
        Nirmal Fernando
      61. PostgreSQL license.jpg
        142 kB
        Nirmal Fernando

        Issue Links

        There are no Sub-Tasks for this issue.

          Activity

            People

            • Assignee:
              Nirmal Fernando
              Reporter:
              Bryan Pendleton
            • Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development