Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
zion99
Posting Yak Master
141 Posts |
 Posted - 2007-09-08 : 14:37:52
|
| Hi All,If we create a non-clustered index on a table which already has a clustered index, does the storage architecture change in any way? I am a little confused about Clustered & non-clustered index. can anybody please suggest me an exhaustive link for this.TIA :) |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-08 : 17:34:14
|
A clustered index changes the way the data is stored, a non-clustered index does not. For more detail check out books online and this is a good resource:http://en.wikipedia.org/wiki/Index_%28database%29
Future guru in the making. |
 |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-08 : 17:36:21
|
Also FYI, this is not the right place for the question, clustering in a high availability sense is a very different thing then a clustered index.
Future guru in the making. |
|
|
|
|
|
|
Change in architecture due to clustering