> Thanks, but this is not what we expected. This means > to change the SQL command in the application. Our > understanding from the manual and other relational DBs > is that, it's suffice for existence of an index on the > field in the criteria (where clause) to run at optimal > speed.
You'll probably get more suggestions if you include in your e-mail: - MySQL version - table layout - query (which you did, but just for the record) - output of explain Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]