MySQL Forums
Forum List  »  Newbie

Re: What is the best way indexing foreign key from multiple table?
Posted by: Phillip Ward
Date: February 14, 2017 08:11AM

Quote

... create a index that is relevant to current situation on how the data is retrieve ...

"By George, I think he's got it!"
That's exactly right.

Quote

How about if I am joining the 3 tables in a query

Same rules apply.
Look at the query execution plan (or slow query log) and see where and when an index would be beneficial - then add it.

Regards, Phill W.

Options: ReplyQuote


Subject
Written By
Posted
Re: What is the best way indexing foreign key from multiple table?
February 14, 2017 08:11AM


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.