Hello.
Similar questions were asked in the list before. For example see: http://lists.mysql.com/mysql/41542 Search in archives at: http://lists.mysql.com/mysql >From sources I've found that this message appears when optimizing queries with count(*), min() and max(). The above message most probably means that you have and index on o_id column, and query would be resolved using only information from the index. $ $ <[EMAIL PROTECTED]> wrote: > When I explain "SELECT MAX(o_id)-10000 FROM orders",it tell me "Select > tables optimized away".What is it meaning?It show me good or bad? > thanks! > > _________________________________________________________________ > $$$$$$$$$$$$$$ MSN Messenger: http://messenger.msn.com/cn > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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]