• Post Reply Bookmark Topic Watch Topic
  • New Topic

Tables without any relationship needs FK index?  RSS feed

 
Rithanya Laxmi
Ranch Hand
Posts: 191
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I have a list of tables without any relationships, since there is no referential integrity between the tables whether we can create any foreign key index for the tables ? or in this case primary key index will suffice? Please clarify.

Thanks
 
Roel De Nijs
Sheriff
Posts: 11095
173
AngularJS Chrome Eclipse IDE Hibernate Java jQuery MySQL Database Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you have tables without any relationships (e.g. Cat and Plane) which foreign keys would you create in these tables The only thing you can do is add a primary key constraint on the unique identifier of each table. And perhaps some (non-unique) indexes to improve performance when searching (and joining).
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!