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

[Alessio Pianigiani]

First of all, thanks for all your replies :)


I'm sorry, but I use MySQLQueryBrowser for all operations on DB

It tells me, when I choose "fine" as an INDEX key, that it can't because it contains NULL values.

I select "INDEX" for fine's index type and when I press Execute it tells me:

ALTER TABLE `gecoprova`.`affidamenti_procuratore` MODIFY COLUMN `fine` DATETIME NOT NULL,
ADD INDEX `FINE`(`fine`);

Where, as you can see, it tries to transform fine column in a NOT NULL column