Database index on generated column to speed up selection on date (for daily stats)

Hello

Database index on generated column to speed up selection on date to easily compile daily statistics:

CREATE TABLE logs (
 ...
 `date` DATETIME,
 -- Generated column for date part (yyy-mm-dd)
 `date_only` DATE AS (DATE(`date`)) STORED,
 ...
 INDEX(`date_only`)
);

With 10 453 162 rows:

• date >= “2026-07-08” → 28 secondes
• date_only >= “2026-07-08” → 2 secondes