MySQL Forums
Forum List  »  Newbie

Re: EXPLAIN shows optimized query
Posted by: Peter Brawley
Date: November 01, 2017 03:28PM

> But if i remove the condition of FK_language_id
> ...
> Now it produces 306 results.

Indeed, because of the Where clause, it couldn't be otherwise, and Select * probably persuades the optimiser that a table scan will be at least as fast.



Edited 1 time(s). Last edit at 11/01/2017 04:19PM by Peter Brawley.

Options: ReplyQuote


Subject
Written By
Posted
October 31, 2017 03:11AM
Re: EXPLAIN shows optimized query
November 01, 2017 03:28PM


Sorry, only registered users may post in this forum.

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.