Re: MySQL can't find index = really slow query...

[Bob Field]

Execute that statement using the command line client only remove the MODIFY...NOT NULL clause:

USE gecoprova;
ALTER TABLE affidamenti_procuratore ADD INDEX FINE(fine);