Home Forums SQL Server 2005 Administering Series of basic index and performance questions RE: Series of basic index and performance questions

  • February 20, 2009 at 8:13 pm

    #948083

    MANU (2/20/2009)

    Gila,

    Why you said that "no index on leading field" for a primary key having two columns?

    TIA,

    MJ

    Because in SQL server, the first column is enforced by an index