Re: [firebird-support] Re: How to specify manual plan for this kind of query?

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

>> Really? I'd suppose the changed part should be:
>> HASH (CTE T T NATURAL, CTE K NATURAL))
>> Dmitry
 
No,
 
My oryginal plan generated by Firebird looks like this
PLAN (SORT (JOIN (CTE T T NATURAL, CTE K INDEX (IXA_NAMES_K__NAME))), HASH (CTE 
T T NATURAL, CTE K INDEX (IXA_FNAMES_K__ID)))
 
and when i have added some condition it is changed to
 
PLAN (SORT (JOIN (CTE T T NATURAL, CTE K INDEX (IXA_NAMES_K__NAME))), JOIN (CTE 
T T NATURAL, CTE K INDEX (IXA_FNAMES_K__ID)))
 
and i need to replace it to oryginal plan
 
Regards,
Karol Bieniaszewski