4 ms·
> Wouldn't the engine be able to use the index to find just the correct rows and then only do the total on those? Yeah, the explanation doesn't really make sen
by masklinn 5y ago
> Wouldn't the engine be able to use the index to find just the correct rows and then only do the total on those?
Yeah, the explanation doesn't really make sense in general, though computing anything might be sufficient to throw off mysql's query optimiser.