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?
|
Results 1 to 9 of 9
Thread: query re-writeThreaded View
|
Click Here to Expand Forum to Full Width |