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 |
|
vaibhavpingle
Starting Member
28 Posts |
 Posted - 2007-06-12 : 12:41:12
|
| Well thank you for answering the last questionAlso harsh, i dont know if you remeber me, but i hav got the job at mastek.Ok now the next question is that.What is better CLUSTERED or NON CLUSTERED index??.please also comment on how efficient the combination of clustered and non clustered index works??thank youTrust in Technology mate .....'Not in Human Beings' |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-06-12 : 12:44:40
|
| There is not an answer for which is better. You need to understand the difference between them. Please check SQL Server Books Online then post a specific question about them.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-12 : 20:24:00
|
| Sql orders data in the table by clustered index. If values in the column change a lot, that column is not a good candidate of clustered index. |
|
|
|
|
|
|
clustered r non clustered