mysql and indexes
| From: | Michael Gale | Date: | Thu, 17 Jun 2004 03:59:55 +0000 |
| Subject: | mysql and indexes | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-34822@lists.php.net to get a copy of this message | ||
Hello,
I know this question is more mysql related then PHP with mysql .. but
....
If I do a "SHOW INDEX from table_name"
I see what appears to be two index for the same column ?
table_name 0 PRIMARY 1 columnname A NULL NULL NULL
table_name 0 columnname 1 columnname A 6623 NULL NULL
Could the multiple index cause a problem ? I am trying to speed up a DB
query ?
Michael.