When all the columns from a table are selected, a PK clustered index is clearly the best option.

This has reference to this article http://sqlserverpedia.com/wiki/Using_the_Right_Indexes_for_Optimal_Performance

dont know what the following makes sense :


LIVE_DATA_301    nonclustered located on PRIMARY        Timestamp


count : 1062425


select * from LiveData301 select * from LiveData301 WITH (INDEX(LIVE_DATA_301))select

GPSString from LiveData301 WITH (INDEX(LIVE_DATA_301))