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
4544
June 16, 2010 07:36AM
1875
June 17, 2010 09:29AM
1616
June 21, 2010 09:24AM
1759
June 21, 2010 06:47PM
Re: Question on bad execution plan
1824
June 22, 2010 07:33AM
1850
June 22, 2010 09:09AM
1718
June 23, 2010 07:44AM
1824
June 24, 2010 12:17AM
1841
June 24, 2010 09:17PM
1683
June 28, 2010 02:39AM
1825
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.