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.

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