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. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php