[jira] [Assigned] (DERBY-6954) Allow plans to execute where HASH tables are estimated to spill to disk.

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[jira] [Assigned] (DERBY-6954) Allow plans to execute where HASH tables are estimated to spill to disk.

JIRA jira@apache.org

     [ 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)
Loading...