Product has been added to your cart.

1.6 Foreign Key and Check Constraints

When you’re trying to cut indexes down to get closer to 5 & 5, sooner or later you’re going to ask, “Should I be indexing my foreign keys?” It’s a religious war: should you define relationships or constraints in the database? What performance difference does it make, good or bad? In this lecture, you’ll learn…

To access this incredible, amazing content, you gotta get Mastering Index Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.

  1. Home
  3. SQL Server Training Classes by Brent Ozar
  5. Mastering Index Tuning
  7. 1.6 Foreign Key and Check Constraints
When you’re trying to cut indexes down to get closer to 5 & 5, sooner or later you’re going to ask, “Should I be indexing my foreign keys?” It’s a religious war: should you define relationships or constraints in the database? What performance difference does it make, good or bad? In this lecture, you’ll learn...
To access this incredible, amazing content, you gotta get Mastering Index Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.
Menu