review and decide what are the necessary indices that are missing

Ilias Pazas 2016-09-13 12:13:40

SQLkiwi 2016-09-14 04:14:52
The Trace index is missing columns RaceID, RecordedOn, and StationID.

CheckPointToStationMap might benefit from an index on StationID with CheckPointID as an included column.

The Athlete index could benefit from adding IsDisqualified to the key.

A more detailed analysis would require a post-execution (Actual) plan, ideally captured directly from Plan Explorer, not imported from SSMS.