@blakeyrat said:My understanding is that MySQL "fixed" the "our database engine sucks ass" problem by adding a completely different "data storage engine" that doesn't suck ass-- so you can actually put MySQL in a mode where it's still using the shitty engine, or you can switch it to use the non-shitty engine. Back when I was working with it daily, it only had the shitty engine, so... I dunno.Correct me if I'm wrong, but last I checked (about a year or so ago) MySQL still shamelessly uses derived tables as a counterfeit form of inline views, regardless of the data storage engine. Of all the other issues it has, there's really nothing like joining large derived tables with no indexes.So... I still avoid MySQL when I can.