MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

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.

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


Subject
Views
Written By
Posted
How to speed up query of indexed column with 5M rows?
24411
ryan zheng
October 09, 2006 06:34AM
Re: How to speed up query of indexed column with 5M rows?
8993
Larry Kagan
October 09, 2006 08:11AM
Re: How to speed up query of indexed column with 5M rows?
7517
ryan zheng
October 10, 2006 12:23AM
Re: How to speed up query of indexed column with 5M rows?
6843
Larry Kagan
October 10, 2006 08:45AM
Re: How to speed up query of indexed column with 5M rows?
6546
Björn Steinbrink
October 12, 2006 07:57PM
Re: How to speed up query of indexed column with 5M rows?
6524
Toa Sty
October 09, 2006 09:40AM
Re: How to speed up query of indexed column with 5M rows?
6119
ryan zheng
October 09, 2006 08:39PM
Re: How to speed up query of indexed column with 5M rows?
5088
KimSeong Loh
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.