Disabling foreign keys
I really don't want *any* inconsistent data in my databases, so I don't want any NO CHECKS on any of the columns. What I have been doing in the past is doing data compares with "Disable foreign keys" on, and then running a script to turn get rid of all NO CHECKS.
It seems that if I don't use "Disable foreign keys" I don't get the NO CHECK issue, but there is a chance the data update will fail. That's ok by me, as I said I don't want any inconsistent data.
So is there any other advantage to using "Disable foreign keys"? I think it might make a performance difference if there is a lot of of data, does anyone know?