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)