| 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> |
|---|---|---|
| ||
| Previous by Date: | SQL Server - Clustered vs Non-clustered, AppDeveloper |
|---|---|
| Next by Date: | Re: SQL Server - Clustered vs Non-clustered, AppDeveloper |
| Previous by Thread: | SQL Server - Clustered vs Non-clustered, AppDeveloper |
| Next by Thread: | Re: SQL Server - Clustered vs Non-clustered, AppDeveloper |
| Indexes: | [Date] [Thread] [Top] [All Lists] |