GilaMonster (11/28/2012)
Pedantic nitpick. The ; is a statement terminator. It does not begin statements. ;WITH is an abomination that I wish would go away.
Agree... sorry 🙂
Maybe. It depends how unique the combinations are (and that goes in general, not for foreign keys).
Do the indexes on FKs have to have the exact same columns by the same order to have impact?
Thanks,
Pedro