MySQL Forums
Forum List  »  Partitioning

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Wrong index used in SELECT , ROW_NUMBER() OVER (PARTITION BY
80
August 20, 2021 09:40PM


Sorry, only registered users may post in this forum.

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.