RE: [PHP-DB] mysql Index?

mySQL will evaluate the indexes that you have created. It will select the one index that best optimizes the search. Therefore, you do not specify an index in your query; mySQL does that for you. -----Original Message----- From: shi [mailto:shimon@oek.dk] Sent: Tuesday, November 06, 2001 9:59 AM To: php-db@lists.php.net Subject: [PHP-DB] mysql Index? Hi group I'm trying to force mysql to use a index, but I get an error in the sql statement. The sql looks like this: select * from indlaeg use index(message) where something = something The problem is, that if it doesn't use the index it will have to search more than 100000 records and that is to slow. I hope that some one can help me Thanks Shimon -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net