Harshvardhan Gupta created DERBY-6954:
-----------------------------------------

             Summary: Allow plans to execute where HASH tables are estimated to 
spill to disk.
                 Key: DERBY-6954
                 URL: https://issues.apache.org/jira/browse/DERBY-6954
             Project: Derby
          Issue Type: Sub-task
            Reporter: Harshvardhan Gupta


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




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to