Hi! On Jun 27, Daniel Rossi wrote: > 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 ?
No. EXPLAIN output is identical, as far as I see, so your FORCE INDEX did nothing. Speed change is probably due to caching. Regards, Sergei -- MySQL Development Team __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]