Screenshot 2021-12-24 at 9.43.17 AM.png
Screenshot 2021-12-24 at 9.46.36 AM.png
[MDEV-27356] optimizer change for inner join vs left join Created: 2021-12-24 Updated: 2021-12-24 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major |
| Reporter: | Khai Ping | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Environment: |
MariaDB 10.6.5 |
||
| Attachments: |
Screenshot 2021-12-24 at 9.43.17 AM.png
Screenshot 2021-12-24 at 9.46.36 AM.png
|
| Description |
|
Hi team, we updated to MariaDB 10.6.5 and noticed that the query plan have change between inner join and left join. The performance seems to have drop drastically for inner join. This is before MariaDB 10.6.5 This is after updating to MariaDB 10.6.5 Is this some where presented in the changelog? |
