News for hackers. Stuff that matters.
Re:A Simple Guide to Five Normal Forms in Relational Databas... by zamalek on Monday September 29, 2014 @10:37AM (#8383003)
Yep, choosing the correct joining method is one of the tasks that a query optimizer (a.k.a. join engine) performs. I think someone around here pointed me toward a document that indicated that there was, at the very least, an experimental competent query optimizer in the MySQL codebase.

Even then it's a far cry away from "the big guns." Things like statistics, DPVs, etc. simply aren't (edit: or weren't) present in MySQL: which are more examples of a critical components of efficient database design at massive load scales.

TLDR; MySQL simply isn't competitive, it's being improved (especially MariaDB) but is a long ways off.

There are no comments on this comment yet.