Corin Langosch <[EMAIL PROTECTED]> wrote: > > update of my last email sent. > > when i use the > sql: 'EXPLAIN SELECT datum FROM actions ORDER BY datum' > > the key gets used: > table type possible_keys key key_len ref rows Extra > actions index NULL datum 8 NULL 75859 Using index > > however as soon as i select more column like > sql: 'EXPLAIN SELECT datum,id FROM actions ORDER BY datum' > the key isn't used anymore :-(. > > might this be bug of mysql? >
No. In the first case MySQL can take all data from the index file. In the second case it should read data file, too. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
