MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: Indexing problems
Posted by: KimSeong Loh
Date: October 25, 2004 08:39PM

OK, got the message and both my assumptions does not hold.
So, lets see the difference in the EXPLAIN statement when the query runs slow and when the query runs fast after index rebuilt.

By the way, are you using InnoDB table type?

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


Subject
Written By
Posted
Indexing problems
James Woodward
October 25, 2004 07:31PM
Re: Indexing problems
KimSeong Loh
October 25, 2004 07:49PM
Re: Indexing problems
James Woodward
October 25, 2004 08:25PM
Re: Indexing problems
KimSeong Loh
October 25, 2004 08:39PM
Re: Indexing problems
James Woodward
October 25, 2004 08:55PM
Re: Indexing problems
James Woodward
October 26, 2004 08:15PM
Re: Indexing problems
KimSeong Loh
October 26, 2004 08:22PM
Re: Indexing problems
James Woodward
October 26, 2004 11:11PM
Re: Indexing problems
KimSeong Loh
October 26, 2004 11:29PM
Re: Indexing problems
James Woodward
October 27, 2004 12:01AM
Re: Indexing problems
KimSeong Loh
October 27, 2004 01:21AM
Re: Indexing problems
James Woodward
October 27, 2004 01:20PM
Re: Indexing problems
KimSeong Loh
October 27, 2004 06:34PM
Re: Indexing problems
James Woodward
October 28, 2004 10:03PM
Re: Indexing problems
KimSeong Loh
October 29, 2004 02:20AM
Re: Indexing problems
James Woodward
November 07, 2004 01:25AM
Re: Indexing problems
James Woodward
October 26, 2004 11:34AM
Re: Indexing problems
Felix Sheng
October 26, 2004 01:48PM
Re: Indexing problems
James Woodward
October 26, 2004 02:14PM
Re: Indexing problems
Seokhee Kim
November 10, 2004 11:18AM


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.