Post reply

Use foreign keys

  • August 24, 2009 at 4:44 pm

    #95985

    Is true, that when i have a table and it has foreign keys, too it must be a index?

  • August 25, 2009 at 7:24 pm

    #1044627

    Its not necessary.

    Keep in mind that when you create foreign keys, an index is not automatically created at the same time. If you ever plan to join a table to the table with the foreign key, using the foreign key as the linking column, then you should consider adding an index to the foreign key column. An index on a foreign key column can substantially boost the performance of many joins.

    http://www.sql-server-performance.com/tips/tuning_joins_p1.aspx

    MJ

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply