Thanks for your quick reply

I quote you

"2 Improves db speed" and this is my primary motivation., but i wonder architecturally if its a good practice.

Limitation here i see is , will this constraint allow me to delete a record in UserInfo table ? or will it just say

Cannot truncate table 'UserInfo' because it is being referenced by a FOREIGN KEY constraint.

Thanks

Zubair