MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Multi-column index issue?
Posted by: Felix Geerinckx
Date: April 27, 2005 07:19AM

Marc Gregoire wrote:

> Is there a way I can speedup such queries? Perhaps by redesigning the table or use multiple tables?

Did you run analyze table foo; (See http://dev.mysql.com/doc/mysql/en/analyze-table.html).

--
felix

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Multi-column index issue?
3886
Marc Gregoire
April 27, 2005 06:21AM
Re: Multi-column index issue?
2397
Felix Geerinckx
April 27, 2005 06:39AM
Re: Multi-column index issue?
2568
Marc Gregoire
April 27, 2005 06:47AM
Re: Multi-column index issue?
2284
Felix Geerinckx
April 27, 2005 07:19AM
Re: Multi-column index issue?
2494
Marc Gregoire
April 27, 2005 07:34AM
Re: Multi-column index issue?
3885
Sergey Petrunya
April 27, 2005 11:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.