Bug #120868 Optimizer misses ORDER BY LIMIT optimization when ordering key is equivalent through join equality
Submitted: 5 Jul 8:42 Modified: 6 Jul 5:29
Reporter: Zack Morgan Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S5 (Performance)
Version:9.7.1 OS:Linux (22.04.4 LTS)
Assigned to: CPU Architecture:x86 (x86_64, Intel(R) Xeon(R) Gold 5220)
Tags: join-order, limit, Optimizer, order-by, performance

To submit contributions, please log in.