This is a common design pattern. In most cases I've seen foreign keys created on CreateUsrID and LastUpdateUsrID that refer back to Usr(UsrID). DRI in this case is probably a good idea. But are indexes on CreateUsrId and LastUpdateUsrID really needed? Indexes probably won't be needed in this design if:
So there you have it. If you aren't traversing your model from parent to child rows or using cascading DRI, then an index on a foreign key column probably won't help you.
Dave Wentzel CONTENT