Issue Details (XML | Word | Printable)

Key: CORE-4823
Type: Improvement Improvement
Status: Open Open
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Karol Bieniaszewski
Votes: 5
Watchers: 4
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Add support for Hash/merge algorithms for outer joins

Created: 01/Jun/15 10:20 AM   Updated: 22/Jan/19 05:35 PM
Component/s: Engine
Affects Version/s: None
Fix Version/s: None

Issue Links:
Duplicate
 
Relate
 

QA Status: No test


 Description  « Hide
example

SELECT
*
FROM
RDB$RELATION_FIELDS RF
left join RDB$RELATIONS R on R.RDB$SYSTEM_FLAG = RF.RDB$FIELD_POSITION
WHERE
RF.RDB$RELATION_NAME BETWEEN 'RDB$RELATIONS' AND 'RDB$RELATIONS2'

PLAN JOIN (RF INDEX (RDB$INDEX_4), R NATURAL)

will be good to see here HASH like is done for inner joins
PLAN HASH (R NATURAL, RF INDEX (RDB$INDEX_4))


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.