March 10, 2010 at 12:52 am
Hii friends,
Can u anyone tell me ,
How can index causes problem for updates ,inserts etc.?
which kind of indexes can cause problem to the same?
Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......
March 10, 2010 at 12:57 am
Indexes are essentially duplicate copies of data (think index at the back of a text book). Since the data's repeated, inserts and updates have to do more work.
How much more? Well, that you'll have to test and see, see if it's a problem in your scenario with your number of indexes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 10, 2010 at 1:11 am
Hii Gail,
in my scenario only 2 indexes are created one is clustered and other is nonclustered
clustered index is created on 1 column which i want to change and create on multiple columns(as per requirement).
but my doubt is "index on 1 column" and "index on multiple columns" which one will or can cause problems to insert,update?
Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......
March 10, 2010 at 5:58 am
http://www.sqlservercentral.com/articles/Indexing/68563/
http://www.sqlservercentral.com/articles/Indexing/68636/
http://sqlinthewild.co.za/index.php/2008/09/23/do-wide-indexes-slow-queries-down/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply