2 ms·
> Granted, it’s not the most optimized way to do it, but more often then not, the resulting query plan is perfectly fine. It usually is the exactly same. (MySQ
by paulddraper 3y ago
> Granted, it’s not the most optimized way to do it, but more often then not, the resulting query plan is perfectly fine.
It usually is the exactly same. (MySQL has a potato for a query optimizer tho.)
The biggest case it is suboptimal is when you need to produce multiple fields from the sub-select. Because then you need multiple sub-selects.