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 or Mastering Index Tuning, or log in if you already shelled out the cash.

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 or Mastering Index Tuning, or log in if you already shelled out the cash.
Menu