[dba-SQLServer] [AccessD] Apples to Oranges

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
>



More information about the dba-SQLServer mailing list