MySQL Forums
Forum List  »  Performance

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

Options: ReplyQuote


Subject
Views
Written By
Posted
3144
April 27, 2005 06:21AM
1988
April 27, 2005 06:39AM
2192
April 27, 2005 06:47AM
Re: Multi-column index issue?
1940
April 27, 2005 07:19AM
2114
April 27, 2005 07:34AM
3349
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.