review and decide what are the necessary indices that are missing
2016-09-13 12:13:40
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.