> > mysql> explain SELECT Tune_Name,Tune_Type FROM Mobile_Tunes; > +--------------+------+---------------+------+---------+------+------+-------+ > | table | type | possible_keys | key | key_len | ref | rows | > Extra | > +--------------+------+---------------+------+---------+------+------+-------+ > | Mobile_Tunes | ALL | NULL | NULL | NULL | NULL | 4 | > | > +--------------+------+---------------+------+---------+------+------+-------+ > 1 row in set (0.00 sec) > mysql> This shows you have NO indexes on the table. Assuming that 'Tune_Name' contains unique entries for each row, I'd suggest you do the following as a minimum: ALTER TABLE Mobile_Tunes ADD PRIMARY KEY (Tune_Name); -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
