If the query cache, key buffer, sort buffer, and various engine configs are too small for the dataset then MySQL will take a less optimal approach. MySQL is an RDBMS for persistent data, not a spreadsheet...

"right tool for the job", etc.