Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-2487

Enhance Derby with EXPLAIN Functionality

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.2.2.0
    • 10.6.1.0
    • SQL
    • None

    Description

      This enhancement extends Derby with EXPLAIN functions. Users want to have more feedback than they`re getting with the current RuntimeStatistics facility. This extension is based on the RuntimeStatistics/ResultSetStatistics functions / classes.

      Attachments

        1. jdbc4tests.diff
          2 kB
          Knut Anders Hatlen
        2. finalReview.diff
          299 kB
          Bryan Pendleton
        3. refactorVisitor.diff
          300 kB
          Bryan Pendleton
        4. refactorVisitor.diff
          297 kB
          Bryan Pendleton
        5. userSchemaPrototyping.diff
          387 kB
          Bryan Pendleton
        6. userSchemaPrototyping.diff
          381 kB
          Bryan Pendleton
        7. userSchemaPrototyping.diff
          472 kB
          Bryan Pendleton
        8. removeSourceDepth.diff
          493 kB
          Bryan Pendleton
        9. startUpgradeTests.diff
          496 kB
          Bryan Pendleton
        10. startRegressionTest.diff
          484 kB
          Bryan Pendleton
        11. startRegressionTest.diff
          455 kB
          Bryan Pendleton
        12. updateRegressionTests.diff
          423 kB
          Bryan Pendleton
        13. updateRegressionTests.diff
          241 kB
          Bryan Pendleton
        14. incorporateTrunkChanges.diff
          222 kB
          Bryan Pendleton
        15. xplain_patch_v1.txt
          471 kB
          Felix Beyer
        16. usage.txt
          5 kB
          Felix Beyer
        17. RSProtocolNew.pdf
          221 kB
          Felix Beyer
        18. small logical xplain schema.pdf
          162 kB
          Felix Beyer
        19. Derby physical XPLAIN schema.png
          42 kB
          Felix Beyer
        20. rts.xls
          29 kB
          Felix Beyer
        21. xplainClasses.pdf
          33 kB
          Felix Beyer

        Issue Links

        relates to

        Bug - A problem which impairs or prevents the functions of the product. DERBY-6216 XPLAIN feature does not work and gives ERROR XCL16: ResultSet not open

        • Major - Major loss of function.
        • Closed

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            bryanpendleton Bryan Pendleton
            fbeyer Felix Beyer
            Votes:
            2 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment