mercredi 28 janvier 2015

Advisable number of foreign keys in a single table


I was wondering, keeping performance and optimizations in mind, while designing the database, is there any advisable number of foreign keys you should keep in a single table?


At present, few of my tables are using 4 foreign keys. Would like to know, if number of foreign keys in a single table causes some performance or scalability issues?


I am using MySql





Aucun commentaire:

Enregistrer un commentaire