Clustered And NonClustered Index

Hi ,
If a table consist of clustered index on column A and Column B by default
when I create a table and define it as primary key.
And I create a non Clustered index on column A , column Y and column Z to
speed up my queries process. Will it consider a duplication of index on
column A ?
Should I defined column A in the non clustered index ?
Travis Tan
Travis
It depends how you build the WHERE condition.
"Travis" <Travis@.discussions.microsoft.com> wrote in message
news:2A5FF224-5B75-4F25-8341-2BC97F9E1368@.microsoft.com...
> Hi ,
> If a table consist of clustered index on column A and Column B by default
> when I create a table and define it as primary key.
> And I create a non Clustered index on column A , column Y and column Z to
> speed up my queries process. Will it consider a duplication of index on
> column A ?
> Should I defined column A in the non clustered index ?
> --
> Travis Tan

Clustered And NonClustered Index

Hi ,
If a table consist of clustered index on column A and Column B by default
when I create a table and define it as primary key.
And I create a non Clustered index on column A , column Y and column Z to
speed up my queries process. Will it consider a duplication of index on
column A ?
Should I defined column A in the non clustered index ?
--
Travis TanTravis
It depends how you build the WHERE condition.
"Travis" <Travis@.discussions.microsoft.com> wrote in message
news:2A5FF224-5B75-4F25-8341-2BC97F9E1368@.microsoft.com...
> Hi ,
> If a table consist of clustered index on column A and Column B by default
> when I create a table and define it as primary key.
> And I create a non Clustered index on column A , column Y and column Z to
> speed up my queries process. Will it consider a duplication of index on
> column A ?
> Should I defined column A in the non clustered index ?
> --
> Travis Tan

Clustered And NonClustered Index

Hi ,
If a table consist of clustered index on column A and Column B by default
when I create a table and define it as primary key.
And I create a non Clustered index on column A , column Y and column Z to
speed up my queries process. Will it consider a duplication of index on
column A ?
Should I defined column A in the non clustered index ?
Travis TanTravis
It depends how you build the WHERE condition.
"Travis" <Travis@.discussions.microsoft.com> wrote in message
news:2A5FF224-5B75-4F25-8341-2BC97F9E1368@.microsoft.com...
> Hi ,
> If a table consist of clustered index on column A and Column B by default
> when I create a table and define it as primary key.
> And I create a non Clustered index on column A , column Y and column Z to
> speed up my queries process. Will it consider a duplication of index on
> column A ?
> Should I defined column A in the non clustered index ?
> --
> Travis Tan

ClusterDistance value

Can somebody please define the result of the ClusterDistance() function for me. BOL and MSDN are vague about what the output means and I am getting some cases that have a value of zero and sometimes there are more than one per cluster.

Thanks in advance,

Dan Meyers

I believe the clusterdistance() is simply 1-clusterprobability(). Are you saying you are getting more that one "0" value of cluster distance for different clusters on a single case?|||No. I am getting more than one case per cluster that has a ClusterDistance() value of "0".|||That's ok - it's an issue if you get more than one cluster per case with a ClusterDistance() of 0. Imagine if you have two identical cases - it would make sense that they have the same ClusterDistance(), would it not?|||

It does make sense. I just wanted to make sure that I was understanding everything correctly and I was not sure because the documentation is a bit vague in its definition of the function.

Thanks Jamie.