MySQL Forums
Forum List  »  Optimizer & Parser

Re: MySQL can't find index = really slow query...
Posted by: Alessio Pianigiani
Date: September 25, 2006 10:14AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL can't find index = really slow query...
1941
September 25, 2006 10:14AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.