What difference does a Clustered Index have, if was created from a primary
key or non-primary key?
Please help me with this questions?
Thank You,Paul
Start with
http://www.sql-server-performance.c...red_indexes.asp
http://www.sql-server-performance.c...red_indexes.asp
"Paul T." <Paul T.@.discussions.microsoft.com> wrote in message
news:F9E308EA-F871-447C-B8BE-2C14347FB80E@.microsoft.com...
> What difference does a Clustered Index have, if was created from a primary
> key or non-primary key?
> Please help me with this questions?
> Thank You,|||UNIQUE
"Paul T." <Paul T.@.discussions.microsoft.com> wrote in message
news:F9E308EA-F871-447C-B8BE-2C14347FB80E@.microsoft.com...
> What difference does a Clustered Index have, if was created from a primary
> key or non-primary key?
> Please help me with this questions?
> Thank You,|||Paul,
The selection of a clustered index is more related to how you use those
columns (the ones that participate in the index key) in your queries than if
they are or not primary keys. The links posted by Uri are a good start to
learn about indexes, and I also recommend BOL and sql server books about
internals and architecture.
Inside Microsoft SQL Server 2000
http://www.amazon.com/gp/product/07...=books&v=glance
Microsoft SQL Server 2000 Unleashed
http://www.amazon.com/gp/product/06...glance&n=283155
The Guru's Guide to SQL Server Architecture and Internals
http://www.amazon.com/gp/product/02...glance&n=283155
AMB
"Paul T." wrote:
> What difference does a Clustered Index have, if was created from a primary
> key or non-primary key?
> Please help me with this questions?
> Thank You,
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment