| Subject | Re: Why does the optimizer choose NATURAL for this tiny table? |
|---|---|
| Author | Dmitry Yemanov |
| Post date | 2014-11-12T19:04:41Z |
12.11.2014 21:48, 'Leyne, Sean' wrote:
sure that both ORed parts are trivially computable.
Dmitry
>Nope, I was interested exactly in that [useless] condition. I want to be
>> 2) ON p.icd10 = t.icd10 OR p.icd10 = t.icd10
>
> I think you meant
> ON p.icd10 = t.icd10 OR p.icd10 = substring(t.icd10 from 1 for 3)
sure that both ORed parts are trivially computable.
Dmitry