| Subject | Re: [firebird-support] Re: How to specify manual plan for this kind of query? |
|---|---|
| Author | liviuslivius |
| Post date | 2019-05-31T13:03:31Z |
>> 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