Re: Help on Query with DATE BETWEEN not performant
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';
Subject
Views
Written By
Posted
1391
February 02, 2020 06:51PM
564
February 02, 2020 07:13PM
555
February 02, 2020 10:30PM
536
February 03, 2020 04:16AM
544
February 03, 2020 08:12AM
553
February 03, 2020 10:45AM
543
February 03, 2020 11:20AM
Re: Help on Query with DATE BETWEEN not performant
517
February 03, 2020 12:02PM
541
February 03, 2020 12:26PM
539
February 03, 2020 04:19PM
596
February 03, 2020 06:21PM
559
February 03, 2020 08:38PM
533
February 04, 2020 01:03PM
544
February 04, 2020 01:42PM
720
February 04, 2020 02:48PM
519
February 04, 2020 05:26PM
543
February 04, 2020 05:27PM
500
February 06, 2020 04:21PM
576
February 06, 2020 04:31PM
540
February 06, 2020 10:57PM
525
February 09, 2020 08:46AM
521
February 09, 2020 11:48AM
507
February 09, 2020 05:04PM
495
February 04, 2020 04:12PM