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

No comments:

Post a Comment

 using Microsoft.AspNetCore.Mvc; using System.Xml.Linq; using System.Xml.XPath; //<table class="common-table medium js-table js-stre...