Wednesday, June 22, 2011

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

This has reference to this article

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))

No comments:

Post a Comment