GilaMonster (3/18/2015)
Koen Verbeeck (3/18/2015)
you can create a new non-clustered index on ID and GPSTime.This, assuming there aren't any other indexes which we haven't been shown
No, better to just add GPSTime to the existing non-clustered index on ID. It can still be a UNIQUE index as teh current one is, adding a key column makes no difference to that.
edit: But as it apparently isn't the ID column after all, I haven't a clue
Tom