sorry i worked it out put it after the table , i got some interesting results
Queried The Database 1 times for 9.9892050027847 seconds +-------+----------+------------------------------+----------+---------+----------------+------+-------------+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-------+----------+------------------------------+----------+---------+----------------+------+-------------+ | sl | fulltext | libraryID,locations,shotlist | shotlist | 0 | | 1 | Using where | | p | eq_ref | PRIMARY,programID | PRIMARY | 1 | sl.programID | 1 | | | r | eq_ref | PRIMARY,reporterID | PRIMARY | 1 | sl.reporterID | 1 | | | tt | eq_ref | PRIMARY,tape_typeID | PRIMARY | 1 | sl.tape_typeID | 1 | | +-------+----------+------------------------------+----------+---------+----------------+------+-------------+ Queried The Database 1 times for 9.9337540864944 seconds +-------+----------+---------------------+----------+---------+----------------+------+-------------+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-------+----------+---------------------+----------+---------+----------------+------+-------------+ | sl | fulltext | libraryID,shotlist | shotlist | 0 | | 1 | Using where | | p | eq_ref | PRIMARY,programID | PRIMARY | 1 | sl.programID | 1 | | | r | eq_ref | PRIMARY,reporterID | PRIMARY | 1 | sl.reporterID | 1 | | | tt | eq_ref | PRIMARY,tape_typeID | PRIMARY | 1 | sl.tape_typeID | 1 | | +-------+----------+---------------------+----------+---------+----------------+------+-------------+ the first was using the force index, the second was without so is adding to force to use and index going to make it slower ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
