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 |
|
rds207
Posting Yak Master
198 Posts |
 Posted - 2009-11-24 : 13:27:09
|
| Can anybody explain clearly with some easy example difference between and clusterd and non clusterd index..i am trying to improve the performance of a view, how does the difference in performance vary with an clustered and non clustered index..and how many non clustered indexes can be for table or a view , i know there should be only one clustered index ..can i have same columns as a clustered and non clustered index...? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
|
|
|
|
|
Clusterd and Non Clusterd Index