🚀 go-pugleaf

Hi.

i have query like this

SELECT
*
FROM
TABLE_B B
INNER JOIN TABLE_A A ON B.ID_OBJ=A.ID
INNER JOIN TABLE_C C ON C.ID_OBJ=A.ID AND B.SYSTEM=C.SYSTEM AND 
C.ZRODLO=:PARAM_X
WHERE
B.KOD=PARAM_Y
AND B.SYSTEM=PARAM_Z

i have plan:

PLAN JOIN (B INDEX (IXA_TABLE_B__KOD__SYSTEM), A INDEX (PK_TABLE_A__ID), C 
INDEX (IXA_TABLE_C__OBJ__ZRO__SYS))

problem is that i have C Natural
when i add left join

SELECT
*
FROM
TABLE_B B
INNER JOIN TABLE_A A ON B.ID_OBJ=A.ID
INNER JOIN (TABLE_C C LEFT JOIN TABLE_D D ON C.ALARM=D.NAZWA) ON 
C.ID_OBJ=A.ID AND B.SYSTEM=C.SYSTEM AND C.ZRODLO=:PARAM_X
WHERE
B.KOD=PARAM_Y
AND B.SYSTEM=PARAM_Z

and now i have this plan

PLAN JOIN (JOIN (C NATURAL,D INDEX (IXAU__TABLE_D__NAZWA)),JOIN (B INDEX 
(IXA_TABLE_B__KOD__SYSTEM, FK_TABLE_B__ID_OBJ), A INDEX (PK_TABLE_A__ID)))


i try also this


SELECT
*
FROM
TABLE_B B
INNER JOIN TABLE_A A ON B.ID_OBJ=A.ID
INNER JOIN TABLE_C C  ON C.ID_OBJ=A.ID AND B.SYSTEM=C.SYSTEM AND 
C.ZRODLO=:PARAM_X
LEFT JOIN TABLE_D D ON C.ALARM=D.NAZWA
WHERE
B.KOD=PARAM_Y
AND B.SYSTEM=PARAM_Z

but without success
now A is NATURAL

PLAN JOIN (JOIN (A NATURAL, ES INDEX (IXA_TABLE_C__OBJ__ZRO__SYS), B INDEX 
(IXA_TABLE_B__KOD__SYSTEM, FK_TABLE_B__ID_OBJ)),D INDEX 
(IXAU__TABLE_D__NAZWA))

table_A have 80 000 records
table_B have 100 000 records
table_C is biggest have 2 800 000 records
table_D have only 60 records

please help
Karol Bieniaszewski