What is the impact of missing foreign keys?

Expert MS SQL

Answer

Missing foreign keys:

  • Prevent automatic referential integrity
  • Hurt query optimization because relationships are unknown
  • Cause poor join strategy selection

Want to bookmark, take notes, or join discussions?

Sign in to access all features and personalize your learning experience.

Sign In Create Account

Source: SugharaIQ

Ready to level up? Start Practice