Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6921 How good is the Derby Query Optimizer, really
  3. DERBY-6954

Allow plans to execute where HASH tables are estimated to spill to disk.

    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: SQL
    • Labels:
      None

      Description

      Derby Optimizer currently rejects the plans where it estimates that intermediate HASH Tables in HASH Joins will spill to disk. We need to model the cost associated of HASH Join disk spill in order to make them a candidate for optimal plan. DERBY-6938, DERBY-1259 and DERBY-106 contain some useful details around this behaviour.

      One possible workaround around this behaviour is to explicitly specify optimizer hints and overriding the default optimizer behaviour.
      https://db.apache.org/derby/docs/10.13/tuning/ctunoptimzoverride.html

        Attachments

          Activity

            People

            • Assignee:
              harshvardhan145 Harshvardhan Gupta
              Reporter:
              harshvardhan145 Harshvardhan Gupta
            • Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: