MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

Re: Wrong index used in SELECT , ROW_NUMBER() OVER (PARTITION BY
Posted by: Peter Brawley
Date: August 20, 2021 09:40PM

The table has no primary key.

What problem are your table partitions meant to solve?

The optimiser seems to have decided that the (`client_id`,`end_date`,`division_id`) index wasn't worth the trouble. Can you prove the optimiser wrong?

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


Subject
Views
Written By
Posted
Wrong index used in SELECT , ROW_NUMBER() OVER (PARTITION BY
1736
Michael Zatkovetsky
August 20, 2021 05:43PM
Re: Wrong index used in SELECT , ROW_NUMBER() OVER (PARTITION BY
629
Michael Zatkovetsky
August 20, 2021 05:48PM
Re: Wrong index used in SELECT , ROW_NUMBER() OVER (PARTITION BY
647
Peter Brawley
August 20, 2021 09:40PM


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.