MySQL Forums
Forum List  »  Performance

Re: does this "top-200" query do a table scan
Posted by: Rick James
Date: October 31, 2015 05:51PM

I agree that the ORDER BY is mandatory.

Use EXPLAIN SELECT ... to see if it is a table scan. It will say "All" if it is.

But note... The optimizer may decide that a table scan is faster than bouncing between the index and the data.

Options: ReplyQuote

Written By
Re: does this "top-200" query do a table scan
October 31, 2015 05:51PM

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.