Materializing Expressions in MySQL with Stored Generated Columns
Use stored generated columns in MySQL 5.7+ to materialize deterministic expressions like LOWER(email) for indexing. This centralizes derived values in schema and avoids per-row function scans, with a trade-off in row size and write amplification.