mysql and indexes

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux