Post reply

Indexing on Foreign Keys is advisable or not?

  • July 30, 2008 at 12:03 pm

    #850754

    Sandy (7/30/2008)

    (Still i wants to know should i create index or not on the foreign key column.....he he he..lolz....:))

    As I said several times in this thread, probably but test to be sure. There are no hard and fast absolutes when it comes to indexing.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 31, 2008 at 2:59 am

    #851088

    Thanks gail...:)

    Cheers!

    Sandy.

    --

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

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