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
3152
April 27, 2005 06:21AM
1993
April 27, 2005 06:39AM
2197
April 27, 2005 06:47AM
Re: Multi-column index issue?
1945
April 27, 2005 07:19AM
2118
April 27, 2005 07:34AM
3357
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.