SQL Server Performance

Nonkey Columns in Nonclustered Indexes

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by travistan, Jun 22, 2009.

  1. travistan New Member

    Hi , I just read an article on Nonkey Columns in Nonclustered Indexes , which using the Include keywords when create index. If the table having Customer No , Customer Create Date , First Name , Last Name , and the query something is refer to Customer No OR Customer Create Date , and look for First Name and Last Name. In the above circumstances , should I create an key index that include Customer No and Customer Create Date and include (First Name and Last Name) ?Thanks ,Travis
    travistan, Jun 22, 2009
    #2

  2. FrankKalis Moderator

    Yes, I think it makes sense to have FirstName and LastName as INCLUDEd columns in the index. That way you have a covering index and there is no need to touch the base table.
    FrankKalis, Jun 22, 2009
    #3

Share This Page