MySQL Forums
Forum List  »  Optimizer & Parser

Re: Question on bad execution plan
Posted by: noicy seal
Date: June 21, 2010 09:24AM

My question is that if the Type in the explain is ALL, why MYSQL still use the key? ALL represent the full table scan, right?

Options: ReplyQuote


Subject
Views
Written By
Posted
4691
June 16, 2010 07:36AM
1921
June 17, 2010 09:29AM
Re: Question on bad execution plan
1660
June 21, 2010 09:24AM
1815
June 21, 2010 06:47PM
1870
June 22, 2010 07:33AM
1904
June 22, 2010 09:09AM
1764
June 23, 2010 07:44AM
1886
June 24, 2010 12:17AM
1888
June 24, 2010 09:17PM
1729
June 28, 2010 02:39AM
1870
June 28, 2010 08:50PM


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.