MySQL Forums
Forum List  »  Optimizer & Parser

Re: How to speed up query of indexed column with 5M rows?
Posted by: KimSeong Loh
Date: October 09, 2006 07:54PM

You should learn to interpret the EXPLAIN result.

The type is ALL which means do a full table scan and no index is used at all for that select statement.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to speed up query of indexed column with 5M rows?
5152
October 09, 2006 07:54PM


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.