Behind the Scenes with Foreign Keys Part 2

(Mark Gillis) The previous blog (Behind the scenes with Foreign Keys part 1) was looking at the impact on your data of switching Foreign Keys (FKs) off and how to clean up the ensuing orphan data. I’m going to move on now to what can happen to your access paths regardless of any data manipulation.