Re: Question on bad execution plan
Hi, Jame
Thanks for your reply.
But I am still confused. Yes, the ALL means table scan. But since the MYSQL use the table scan, why the mysql still use the key(index) in the explain?
Subject
Views
Written By
Posted
4647
June 16, 2010 07:36AM
1903
June 17, 2010 09:29AM
1646
June 21, 2010 09:24AM
1797
June 21, 2010 06:47PM
Re: Question on bad execution plan
1856
June 22, 2010 07:33AM
1893
June 22, 2010 09:09AM
1750
June 23, 2010 07:44AM
1868
June 24, 2010 12:17AM
1873
June 24, 2010 09:17PM
1716
June 28, 2010 02:39AM
1858
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.