>   
> 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

Reply via email to