in reply to MySQL Select Speed Optimisation

Update: This isn't what you asked: I misread your question.

From the MySQL docs: 

mysql> SHOW INDEX FROM mytable FROM mydb;
mysql> SHOW INDEX FROM mydb.mytable;

[download]
Running this myself shows it does do an index automatically
cheers
davis
It's not easy to juggle a pregnant wife and a troubled child, but somehow I managed to fit in eight hours of TV a day.

In Section Seekers of Perl Wisdom