MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Why can't MySQL use a range over a Clustered Primary Key
Posted by: Peter Brawley
Date: January 20, 2022 10:43AM

With an analogous table, I find MySQL 8.0.27 uses the appropriate compound index in a subquery (with or without the Group BY, which I think doesn't help). What version are you using? Let's see the Explain result.

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


Subject
Written By
Posted
Why can't MySQL use a range over a Clustered Primary Key
Paul Dugdale
January 20, 2022 05:58AM
Re: Why can't MySQL use a range over a Clustered Primary Key
Peter Brawley
January 20, 2022 10:43AM
Re: Why can't MySQL use a range over a Clustered Primary Key
Paul Dugdale
January 20, 2022 11:56AM
Re: Why can't MySQL use a range over a Clustered Primary Key
Peter Brawley
January 20, 2022 08:45PM


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.