Product has been added to your cart.

3.4 Foreign Key and Check Constraints

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 why telling SQL Server about your data can lead to better execution plans, but worse deletes/updates on cascades. Demo scripts: Transact-SQL /* Mastering Index Tuning – Foreign Keys…

To access this incredible, amazing content, you gotta get Live Class Season Pass, 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. 3.4 Foreign Key and Check Constraints
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 why telling SQL Server about your data can lead to better execution plans, but worse deletes/updates on cascades. Demo scripts: Transact-SQL /* Mastering Index Tuning - Foreign Keys...
To access this incredible, amazing content, you gotta get Live Class Season Pass, Mastering Index Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.
Menu