Post reply

Performance with foreign key

  • May 14, 2009 at 7:08 am

    #994475

    PaulB (5/14/2009)

    sabutp (5/14/2009)I am not sure in MS SQL but in Sysbase SQL separate indexes are created automatically for primary and foreign keys.

    MS SQL Server != Sybase

    They departed ways when SQL Server released version 4.2

    In... what was that, 1995? I was working with both back then.

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

  • May 14, 2009 at 7:31 am

    #994498

    Grant Fritchey (5/14/2009)In... what was that, 1995? I was working with both back then.

    :w00t: So I'm not the only dinosaur around, huh? 😀

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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

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