liviu.costea:

Parerea mea e ca unul din indecsii astia doi e in plus, mai bine spus al doilea.

Legat de indexul pe 7 coloane : cred ca acestea fac parte dintr-un index cu optiunea include columns. Citez din books online :

"

Indexes that include nonkey columns provide the greatest benefit when they cover the query. This means the indexes include all columns referenced by the query. For more information see Index with Included Columns.

USE AdventureWorks;
GO
CREATE NONCLUSTERED INDEX IX_Address_PostalCode
ON Person.Address (PostalCode)
INCLUDE (AddressLine1, AddressLine2, City, StateProvinceID);
"