Thanks for your replies regarding to my previous query.
We have encountered another problem:
MySQL 4.0.14, INNODB.
A table does have an Index on Field1, this field
(Field1) is also the Primary Key. Querying on this
field takes a long time, running along with Explain
command it displays that it does not use the index. Prior converting to INNODB it had been working fine in
MYISAM.
What could cause this problem?
Can you provide us with the EXPLAIN of the query, a DESCRIBE TABLE and a SHOW INDEX to help us pinpoint what the problem is?
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
