macromedia.coldfusion.getting_started
[Top] [All Lists]

Re: SQL Server - Clustered vs Non-clustered

Subject: Re: SQL Server - Clustered vs Non-clustered
From: Ian Skinner
Date: Tue, 09 Sep 2008 13:50:31 -0700
Newsgroups: macromedia.coldfusion.getting_started

AppDeveloper wrote:
Hi,

When should I use clustered index versus non-clustered index?

Thanks in advance!
IIRC Non-Cluster Indexes are used when the values in the index field(s)
are unique across all records.
Clustered Indexes are when the values are *not* unique and thus come in
'clusters' of values.




<Prev in Thread] Current Thread [Next in Thread>