jwcolby
jwcolby at colbyconsulting.com
Mon Oct 4 16:36:49 CDT 2010
With an index, both databases took 2 seconds to return the results. John W. Colby www.ColbyConsulting.com On 10/4/2010 5:16 PM, jwcolby wrote: > I On the new server, have the same database on my SSD (two drive) raid 0 and a rotating media (2 > drive) Raid 0. > > There is a clustered index on the PK as the index key. > There is no index on the FieldX, forcing a field scan. > > I did a simple count PK Group By FieldX on both database files. > > The SSD returned the counts in 1:31 > The rotating media returned the counts in 8:58 >