Friday, February 10, 2012

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

No comments:

Post a Comment