mysql Index?
| From: | shi | Date: | Tue, 06 Nov 2001 15:58:32 +0000 |
| Subject: | mysql Index? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14055@lists.php.net to get a copy of this message | ||
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