MySQL Forums
Forum List  »  Database Administration & Monitoring

Advanced Search
New Topic

Re: Slow Left Join on 100K row tables
Posted by: Peter Brawley
Date: March 10, 2022 12:11PM

SQL has no way to optimise Left Joins as well as Inner Joins, but I notice that a an exclusion join similar to yours on 191K rows takes 2'42" here on 5.7 and just 3 secs on 8.0.28.

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


Subject
Written By
Posted
Slow Left Join on 100K row tables
Biju Philips
March 09, 2022 08:58PM
Re: Slow Left Join on 100K row tables
Peter Brawley
March 09, 2022 11:17PM
Re: Slow Left Join on 100K row tables
Biju Philips
March 10, 2022 10:54AM
Re: Slow Left Join on 100K row tables
Peter Brawley
March 10, 2022 12:11PM


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.