ANSI Outer Join uses wrong Plan

Discussion forum about all things SqlBase.
FRBhote
India
Posts: 1231
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

ANSI Outer Join uses wrong Plan

Post by FRBhote » 01 Sep 2018, 06:35

SB 8.5

Using the ANSI Left Outer join takes much longer to execute. Is this true for newer versions of SB also?

SELECT S_PARTY, S_BILL_NO, S_CONTRACT
FROM SYSADM.SAUDA LEFT OUTER JOIN SYSADM.ISIN ON S_CO = ISIN_CO
WHERE S_PARTY = '01DC221' AND S_DATE = 2018-07-31;


OUTER TBL INDEX USED-O INNER TBL INDEX USED-I RESULT TBL JOIN METHOD
================== ================== =================== =========== ==================== ============
SAUDA ISIN RESULT HASH JOIN



SELECT S_PARTY, S_BILL_NO, S_CONTRACT
FROM SYSADM.SAUDA, SYSADM.ISIN
WHERE S_CO = ISIN_CO(+) AND S_PARTY = '01DC221' AND S_DATE = 2018-07-31;

OUTER TBL INDEX USED-O INNER TBL INDEX USED-I RESULT TBL JOIN METHOD
================== ==================================== =================== =========== ===============
SAUDA XS_PARTY ISIN XISIN_CO RESULT INDEX LOOP

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests