What are the performance trade-offs of using scalar functions inside JOIN or GROUP BY clauses?

Using scalar functions on columns may prevent MySQL from using indexes, leading to full table scans.

Functions are evaluated for every row processed, which increases CPU usage and slows down queries on large datasets.

In JOINs, applying functions on join keys can significantly degrade performance because the database cannot efficiently match rows using indexed keys.