Re: Composite vs Single Foreign Keys
Posted by: Peter Brawley
Date: March 11, 2016 10:56AM

Compound FKs can be more difficult to maintain. Are you sure you don't wish to handle these relationships as just lookups?

One vs two indexes depends entirely on how queries are written, which is why writing all anticipated queries is part of db design. So put in some samole data, write the queries, run them through Explain, and see what the MySQL optimiser says.

Options: ReplyQuote


Subject
Written By
Posted
Re: Composite vs Single Foreign Keys
March 11, 2016 10:56AM


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.