Foreign keys are an essential part of a relational database. Foreign keys helps ensuring the data integrity at the logical level. However many time we forget to create proper indexes that support the foreign keys work effectively. So is there any benefits of indexing the foreign key columns?  It can give… Continue Reading Foreign key indexing