[dba-SQLServer] Apples to Oranges

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



More information about the dba-SQLServer mailing list