Index Wizard Non-Cluster/Cluster Indexes

13 Nov 2005 10:22 PM

Joe K.

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,

13 Nov 2005 10:41 PM

Mike Epprecht (SQL MVP)

Hi

Have a look at
http://www.sql-server-performance.com/gv_index_data_structures.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: m***@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

Show quote

"Joe K." <J***@discussions.microsoft.com> wrote in message
news:5C16AC20-C2D7-4012-9BDF-02C767FAE0FA@microsoft.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,