From: A Z (xtcsukyahoo.co.uk)
Date: Mon Mar 22 2004 - 07:48:53 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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?

regards

        
        
                
___________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]