Hello.
I've checked this and found that ANALYZE table really doesn't work, but OPTIMIZE table made its work. In case it won't help you send to list complete definitions of you tables and queries. Allan Miller wrote: > Hi Gleb, > > Thanks for the quick response. Unfortunately, ANALYZE TABLE does not > appear to affect the Cardinality field of a temporary table (it is > still NULL, even with rows added). Only by creating the index itself > after the insert seems to make the query faster. I also tried FORCE > INDEX and it did not make things any faster. > > Do you have any idea why creating the index AFTER putting the data in > the table affects the performance so dramatically? > > Allan > -- 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]
