Infrequently used 1:n relation - foreign key vs relation table RRS feed

  • Question

  • Hi!

    Is it better to create a relation table for a infrequently used weak relation or a nullable foreign key in the n entity? In my case about 0.1% of the n entity are related to the 1 entity. Which solution performs better?



    • Moved by Tom PhillipsEditor Friday, August 6, 2010 7:07 PM Database Design Question (From:SQL Server Database Engine)
    Friday, August 6, 2010 6:04 PM