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
1380
February 02, 2020 06:51PM
560
February 02, 2020 07:13PM
550
February 02, 2020 10:30PM
532
February 03, 2020 04:16AM
538
February 03, 2020 08:12AM
548
February 03, 2020 10:45AM
538
February 03, 2020 11:20AM
Re: Help on Query with DATE BETWEEN not performant
514
February 03, 2020 12:02PM
534
February 03, 2020 12:26PM
532
February 03, 2020 04:19PM
580
February 03, 2020 06:21PM
553
February 03, 2020 08:38PM
525
February 04, 2020 01:03PM
539
February 04, 2020 01:42PM
697
February 04, 2020 02:48PM
516
February 04, 2020 05:26PM
538
February 04, 2020 05:27PM
495
February 06, 2020 04:21PM
571
February 06, 2020 04:31PM
537
February 06, 2020 10:57PM
520
February 09, 2020 08:46AM
518
February 09, 2020 11:48AM
497
February 09, 2020 05:04PM
491
February 04, 2020 04:12PM