jwcolby
jwcolby at colbyconsulting.com
Mon Oct 4 16:16:33 CDT 2010
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 -- John W. Colby www.ColbyConsulting.com