Yeah, I wouldn't expect MySQL to support this optimization either. Also, views often perform worse than if you put the view's query inline in the query using the view, which is baffling.

Query optimisation remains a critical discipline in database systems, underpinning the efficiency and responsiveness of data-driven applications. By selecting optimal execution plans, modern query ...

The Multi-Query Optimization (MQO) problem is a class of data-intensive problems that are NP-hard, and it has applications in many fields such as database query optimization, machine learning ...