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

Enable optimizer trace in Derby

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 10.2.1.6
    • None
    • SQL
    • Normal

    Description

      Derby engine has code to produce trace for optimization phase ie various plans considered by the optimizer for a query. This trace however does not get produced because there is no way to turn the trace on. When someone does work on providing a way to enable the optimizer trace, we will also need to decide in what format this trace should be presented. Further information on this issue can be found at http://article.gmane.org/gmane.comp.apache.db.derby.devel/12288

      Attachments

        1. enableOptimizerTraceHacksvndiff.txt
          3 kB
          Mamta A. Satoor
        2. enableOptimizerTraceHacksvnstat.txt
          0.4 kB
          Mamta A. Satoor

        Issue Links

          relates to

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-6022 Add a system procedure for (un)registering optional packages of Derby tools.

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-6211 Make Optimizer trace logic pluggable.

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Unassigned Unassigned
              mamtas Mamta A. Satoor
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: