Re: EXPLAIN shows optimized query
> 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.
Subject
Written By
Posted
November 01, 2017 01:19PM
November 01, 2017 02:11PM
November 01, 2017 02:42PM
Re: EXPLAIN shows optimized query
November 01, 2017 03:28PM
November 02, 2017 04:02AM
November 02, 2017 09:09AM
November 18, 2017 12:18AM
November 18, 2017 11:18AM
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.