Re: Help on Query with DATE BETWEEN not performant

[Peter Brawley]

It seems peculiar, we're missing something, did you try reversing the join eg ...

select ca.fk_earticle
from ecust_user_contract u  
join econtracts_articles ca on u.fk_contract=ca.fk_econtract 
join earticles a on ca.fk_earticle=a.id 
               and a.dateOfArticle between '2019/01/02' AND '2020/02/02'
where u.fk_cust_user='mihaluka';