[
https://issues.apache.org/jira/browse/DERBY-6954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Harshvardhan Gupta reassigned DERBY-6954:
-----------------------------------------
Assignee: Harshvardhan Gupta
> 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
> Components: SQL
> Reporter: Harshvardhan Gupta
> Assignee: 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)
