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.

Open source has brought a lot more than Linux to the computing world. It has also given us PHP and MySQL. In the first installment of this three-lesson tutorial, we cover everything you need to ...

Sponsored Post Optimizing MySQL database performance, especially in heavy demand public cloud services, is a key challenge for data base administrators. IT operations and maintenance developers have ...