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>