Originally posted by slimdave
A composite index on ParticipantID, ParticipantIDMM, InstrumentID, and maybe timesamp sounds like a good idea. Although 200 rows is so little that the index might possibly get ignored.

Are you sure that the distinct is also required?
To Add, If Card of these Cols is pretty less, go for BIT Map Index.

Else Normal.