Skip navigation links

MySQL Forums :: Performance :: Long execution time despite LIMIT 3


Advanced Search

Re: Long execution time despite LIMIT 3
Posted by: Rick James ()
Date: June 23, 2011 08:53AM

That's because InnoDB (not MyISAM) silently appends the PRIMARY KEY fields to every secondary key. So, effectively, those indexes are identical. (Sorry, I should have included id so that this puzzle would not arise.)

Options: Reply•Quote


Subject Views Written By Posted
Long execution time despite LIMIT 3 932 Joachim Berger 06/19/2011 12:47PM
Re: Long execution time despite LIMIT 3 436 Joachim Berger 06/19/2011 12:54PM
Re: Long execution time despite LIMIT 3 406 Rick James 06/20/2011 06:33PM
Re: Long execution time despite LIMIT 3 372 Joachim Berger 06/20/2011 11:44PM
Re: Long execution time despite LIMIT 3 402 Joachim Berger 06/21/2011 02:06AM
Re: Long execution time despite LIMIT 3 400 Rick James 06/21/2011 07:23AM
Re: Long execution time despite LIMIT 3 363 Joachim Berger 06/21/2011 07:28AM
Re: Long execution time despite LIMIT 3 431 Joachim Berger 06/21/2011 10:33AM
Re: Long execution time despite LIMIT 3 468 Rick James 06/21/2011 10:08PM
Re: Long execution time despite LIMIT 3 559 Joachim Berger 06/22/2011 12:33AM
Re: Long execution time despite LIMIT 3 436 Rick James 06/22/2011 07:26PM
Re: Long execution time despite LIMIT 3 390 Joachim Berger 06/22/2011 11:45PM
Re: Long execution time despite LIMIT 3 349 Rick James 06/23/2011 08:53AM
Re: Long execution time despite LIMIT 3 454 Joachim Berger 06/24/2011 02:51AM


Sorry, you can't reply to this topic. It has been closed.
powered by phorum

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.