Derby
  1. Derby
  2. DERBY-2487

Enhance Derby with EXPLAIN Functionality

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Minor 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.

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

        Issue Links

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development