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

Enhance Derby with EXPLAIN Functionality

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 10.2.2.0
    • Fix Version/s: 10.6.1.0
    • Component/s: SQL
    • Labels:
      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. xplainClasses.pdf
          33 kB
          Felix Beyer
        2. xplain_patch_v1.txt
          471 kB
          Felix Beyer
        3. userSchemaPrototyping.diff
          472 kB
          Bryan Pendleton
        4. userSchemaPrototyping.diff
          381 kB
          Bryan Pendleton
        5. userSchemaPrototyping.diff
          387 kB
          Bryan Pendleton
        6. usage.txt
          5 kB
          Felix Beyer
        7. updateRegressionTests.diff
          241 kB
          Bryan Pendleton
        8. updateRegressionTests.diff
          423 kB
          Bryan Pendleton
        9. startUpgradeTests.diff
          496 kB
          Bryan Pendleton
        10. startRegressionTest.diff
          455 kB
          Bryan Pendleton
        11. startRegressionTest.diff
          484 kB
          Bryan Pendleton
        12. small logical xplain schema.pdf
          162 kB
          Felix Beyer
        13. rts.xls
          29 kB
          Felix Beyer
        14. RSProtocolNew.pdf
          221 kB
          Felix Beyer
        15. removeSourceDepth.diff
          493 kB
          Bryan Pendleton
        16. refactorVisitor.diff
          297 kB
          Bryan Pendleton
        17. refactorVisitor.diff
          300 kB
          Bryan Pendleton
        18. jdbc4tests.diff
          2 kB
          Knut Anders Hatlen
        19. incorporateTrunkChanges.diff
          222 kB
          Bryan Pendleton
        20. finalReview.diff
          299 kB
          Bryan Pendleton
        21. Derby physical XPLAIN schema.png
          42 kB
          Felix Beyer

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: