Home Forums SQL Server 2005 Administering Missing Indexes RE: Missing Indexes

  • October 10, 2012 at 11:29 pm

    #1547886

    sunny.tjk (10/10/2012)

    So, can I create separate NC indexes on OFFR_TYPE_CD and CRETD_DT columns

    No. Single composite index is better.

    also can I create a composite index on [LKUP_ID] and [ATTR_VAL] columns?

    Yes.