Foreign keys should have indexes on them, and it should often cover multiple columns base on the queries you need to execute. You should make sure about the referential integrity by enforcing the Foreign Keys. Choose right column for CLUSTER Index. You should apply proper indexes and do not create…