Ars Technica

MSSQL: Any benefit to adding an index to a foreign key field?

Sample database<BR><BR>[Customer]<BR>ID (PK, identity)<BR>FirstName<BR>LastName<BR><BR>[Order]<BR>ID (PK, identity)<BR>CustomerID (FK to Customer)<BR><BR>By default SQL Server creates clustered ...