[dba-VB] 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

More information about the dba-VB mailing list