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 |
|
sgondesi
Posting Yak Master
200 Posts |
 Posted - 2013-10-30 : 13:57:39
|
| why is it recommended that,Clustered indexes should be created on tables which are frequently modified. &Non-Clustered indexes should be created on tables which are frequently queried.someone please explain me why.-- Thanks and RegardsSrikar Reddy Gondesi,Trainee SQL Server Database AdministratorMiracle Software systems, Inc. |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-10-30 : 14:09:23
|
quote:
Originally posted by sgondesi
why is it recommended that,Clustered indexes should be created on tables which are frequently modified. &Non-Clustered indexes should be created on tables which are frequently queried.someone please explain me why.-- Thanks and RegardsSrikar Reddy Gondesi,Trainee SQL Server Database AdministratorMiracle Software systems, Inc.
Where does it say that?As in everything, there are no hard and fast rules in SQL, so those statements are not necessarily gospel. |
 |
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2013-10-31 : 03:27:02
|
quote:
Originally posted by James K
quote:
Originally posted by sgondesi
why is it recommended that,Clustered indexes should be created on tables which are frequently modified. &Non-Clustered indexes should be created on tables which are frequently queried.someone please explain me why.-- Thanks and RegardsSrikar Reddy Gondesi,Trainee SQL Server Database AdministratorMiracle Software systems, Inc.
Where does it say that?As in everything, there are no hard and fast rules in SQL, so those statements are not necessarily gospel.
I read that in a website.actually i lost all my tabs opened in my google chrome due to some problem.so i cannot send you that site address.ok let me ask in other way.Non clustered Index with clustered index is effective or non clustered index with heap is effective?-- Thanks and RegardsSrikar Reddy Gondesi,Trainee SQL Server Database AdministratorMiracle Software systems, Inc. |
|
|
|
|
|
|
|
|
Which index should be created where