MySQL Forums
Forum List  »  Optimizer & Parser

Re: Indexing a small table increases the query cost
Posted by: Aram Mirzadeh
Date: February 28, 2018 11:30AM

Here are the two visual explains:

https://imageshack.com/a/img924/6966/WgKc09.png
https://imageshack.com/a/img923/3681/uRBHvi.png

3200 is with INDEX on the sub-tbales only
242 is without INDEX on the sub-tables only

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Indexing a small table increases the query cost
144
February 28, 2018 11:30AM


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.