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
144
Michael Zatkovetsky
August 20, 2021 05:43PM
Re: Wrong index used in SELECT , ROW_NUMBER() OVER (PARTITION BY
64
Michael Zatkovetsky
August 20, 2021 05:48PM
Re: Wrong index used in SELECT , ROW_NUMBER() OVER (PARTITION BY
80
Peter Brawley
August 20, 2021 09:40PM


Sorry, only registered users may post in this forum.
Click here to login

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.