MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Help on Query with DATE BETWEEN not performant
Posted by: Edwin Desouza
Date: February 09, 2020 05:04PM

yes, as Peter recommends:
- please test with 8.0.19
- and, post the EXPLAIN ANALYZE



MySQL 8.0: Hash Join and EXPLAIN ANALYZE
- https://www.slideshare.net/NorvaldRyeng/mysql-8018-latest-updates-hash-join-and-explain-analyze


MySQL 8.0: EXPLAIN ANALYZE
- https://mysqlserverteam.com/mysql-explain-analyze/
- https://www.percona.com/blog/2019/10/28/using-explain-analyze-in-mysql-8/
- https://dev.mysql.com/doc/refman/8.0/en/explain.html#explain-analyze

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Help on Query with DATE BETWEEN not performant
2622
Kristijan Marin
February 02, 2020 06:51PM
Re: Help on Query with DATE BETWEEN not performant
935
Kristijan Marin
February 02, 2020 07:13PM
Re: Help on Query with DATE BETWEEN not performant
907
Peter Brawley
February 02, 2020 10:30PM
Re: Help on Query with DATE BETWEEN not performant
908
Kristijan Marin
February 03, 2020 04:16AM
Re: Help on Query with DATE BETWEEN not performant
879
Kristijan Marin
February 03, 2020 08:12AM
Re: Help on Query with DATE BETWEEN not performant
1578
Peter Brawley
February 03, 2020 10:45AM
Re: Help on Query with DATE BETWEEN not performant
946
Kristijan Marin
February 03, 2020 11:20AM
Re: Help on Query with DATE BETWEEN not performant
859
Peter Brawley
February 03, 2020 12:02PM
Re: Help on Query with DATE BETWEEN not performant
876
Kristijan Marin
February 03, 2020 12:26PM
Re: Help on Query with DATE BETWEEN not performant
880
Peter Brawley
February 03, 2020 04:19PM
Re: Help on Query with DATE BETWEEN not performant
1601
Kristijan Marin
February 03, 2020 06:21PM
Re: Help on Query with DATE BETWEEN not performant
897
Peter Brawley
February 03, 2020 08:38PM
Re: Help on Query with DATE BETWEEN not performant
1610
Kristijan Marin
February 04, 2020 01:03PM
Re: Help on Query with DATE BETWEEN not performant
1009
Peter Brawley
February 04, 2020 01:42PM
Re: Help on Query with DATE BETWEEN not performant
1700
Kristijan Marin
February 04, 2020 02:48PM
Re: Help on Query with DATE BETWEEN not performant
1609
Peter Brawley
February 04, 2020 05:26PM
Re: Help on Query with DATE BETWEEN not performant
1292
Peter Brawley
February 04, 2020 05:27PM
Re: Help on Query with DATE BETWEEN not performant
854
Kristijan Marin
February 06, 2020 04:21PM
Re: Help on Query with DATE BETWEEN not performant
1124
Kristijan Marin
February 06, 2020 04:31PM
Re: Help on Query with DATE BETWEEN not performant
1602
Peter Brawley
February 06, 2020 10:57PM
Re: Help on Query with DATE BETWEEN not performant
1277
Kristijan Marin
February 09, 2020 08:46AM
Re: Help on Query with DATE BETWEEN not performant
892
Peter Brawley
February 09, 2020 11:48AM
Re: Help on Query with DATE BETWEEN not performant
1652
Edwin Desouza
February 09, 2020 05:04PM
Re: Help on Query with DATE BETWEEN not performant
811
Kristijan Marin
February 04, 2020 04:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.