On Wed, 23 Oct 2002 19:15:59 +0300 "Andrey Hristov" <[EMAIL PROTECTED]> wrote:
> I am not an expert but I think that when there is not order by the > output is sorted on the primary key. > So : select * from log_answers_index limit 0,10 and select * from > log_ansers_index where log_entry_id between 1 and 10 > are no different in the output. But yes as internal work (of mysql) it > is quite different. > I think that will be useful optimization done by the optimizer. > > > Andrey > > HI! If there is an index on the column and if table is large enough, MySQL will use it for ORDERing. Do not forget that for a single table instance MySQL can use only one index. Can you provide us a case where MySQL does not use index ??? -- Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php