| Mike Epprecht \(SQL MVP\) 2005-11-13, 8:23 pm |
| Hi
Have a look at
http://www.sql-server-performance.c...
ures.asp
The number of IO requests that need to be done depends on what you are doing
and what your table structure look like.
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Joe K." <JoeK@discussions.microsoft.com> wrote in message
news:5C16AC20-C2D7-4012-9BDF- 02C767FAE0FA@microso
ft.com...
>
> I have primary key that is increasing integer value on a SQL Server 2000
> database.
>
> Is it more efficient to make this a Cluster or Non-Cluster index?
>
> How many trips to the disk does it take to retreive data from a cluster or
> non-cluster index?
>
> Are there 3rd party packages that do a good job evaluating cluster and
> non-cluster indexes?
>
> Thank You,
|