clustered vs non clustered indexes

can someone bottom line this for me? whats the difference between the two
and how do I know when to use which type?
any info is greatly appreciated. Thanks.The first place to look for information about sql server is in the online
documentation (BOL - Books Online).
Creating and Maintaining Databases/Indexes/Designing an Index/Using
Clustered Indexes
This section has a wealth of information about indexes. Try giving that a
thorough reading.
"djc" <noone@.nowhere.com> wrote in message
news:uFq3wSlmEHA.324@.TK2MSFTNGP11.phx.gbl...
> can someone bottom line this for me? whats the difference between the two
> and how do I know when to use which type?
> any info is greatly appreciated. Thanks.
>|||As Scott states you should read up on it but the main difference is that you
can only have one clustered index per table since it physically sorts the
data in the order of the column(s) in the index expression. The leaf level
(lowest level) of the clustered index is the actual row of data where as in
a non-clustered index the leaf level points to the key in the clustered
index. Most tables should have a clustered index if for no other reason as
that is the only way to control fragmentation and avoid forwarding pointers.
But a CI can be extremely useful with lookups especially if you have range
type queries that use the expression the Ci is built on.
--
Andrew J. Kelly SQL MVP
"djc" <noone@.nowhere.com> wrote in message
news:uFq3wSlmEHA.324@.TK2MSFTNGP11.phx.gbl...
> can someone bottom line this for me? whats the difference between the two
> and how do I know when to use which type?
> any info is greatly appreciated. Thanks.
>|||Thanks Scott. I may have to do that but I was hoping for one of the experts
here to bottom line it for me since I don't need all the detail yet. I'm
just being resourceful.
Thanks for the reply though.
"Scott Morris" <bogus@.bogus.com> wrote in message
news:%233J0%23hlmEHA.2864@.tk2msftngp13.phx.gbl...
> The first place to look for information about sql server is in the online
> documentation (BOL - Books Online).
> Creating and Maintaining Databases/Indexes/Designing an Index/Using
> Clustered Indexes
> This section has a wealth of information about indexes. Try giving that a
> thorough reading.
> "djc" <noone@.nowhere.com> wrote in message
> news:uFq3wSlmEHA.324@.TK2MSFTNGP11.phx.gbl...
> > can someone bottom line this for me? whats the difference between the
two
> > and how do I know when to use which type?
> >
> > any info is greatly appreciated. Thanks.
> >
> >
>|||That will do. Thank you very much!
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:ODyJ5ulmEHA.2764@.TK2MSFTNGP11.phx.gbl...
> As Scott states you should read up on it but the main difference is that
you
> can only have one clustered index per table since it physically sorts the
> data in the order of the column(s) in the index expression. The leaf
level
> (lowest level) of the clustered index is the actual row of data where as
in
> a non-clustered index the leaf level points to the key in the clustered
> index. Most tables should have a clustered index if for no other reason
as
> that is the only way to control fragmentation and avoid forwarding
pointers.
> But a CI can be extremely useful with lookups especially if you have range
> type queries that use the expression the Ci is built on.
> --
> Andrew J. Kelly SQL MVP
>
> "djc" <noone@.nowhere.com> wrote in message
> news:uFq3wSlmEHA.324@.TK2MSFTNGP11.phx.gbl...
> > can someone bottom line this for me? whats the difference between the
two
> > and how do I know when to use which type?
> >
> > any info is greatly appreciated. Thanks.
> >
> >
>