[ https://issues.apache.org/jira/browse/DERBY-6938?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Harshvardhan Gupta updated DERBY-6938: -------------------------------------- Attachment: traceout.txt Following my previous comment I am also attaching the sample optimizer trace of Query 1a of job dataset where Optimizer ignores the HASH Tables which it predicts will spill to disk. trace output String - "Skipping access path due to excess memory usage, maximum is 1048576". > Obtain cardinality estimates and true estimates for base tables as well as > for intermediate results for queries involving multiple joins. > ------------------------------------------------------------------------------------------------------------------------------------------- > > Key: DERBY-6938 > URL: https://issues.apache.org/jira/browse/DERBY-6938 > Project: Derby > Issue Type: Sub-task > Components: SQL > Reporter: Harshvardhan Gupta > Assignee: Harshvardhan Gupta > Attachments: explain.txt, traceout.txt > > -- This message was sent by Atlassian JIRA (v6.4.14#64029)