This is not uncommon for you to come across a large table with lot of indexes. But Have you ever tried to see if there is any duplicate Indexes exists for that table?
For example If I have a table say "Customer" and define one Non clustered Index on FirstName and then I define another index on FirstName and LastName then Firstname appears twice and the first Index can be called redundant and is not required.
Disadvantages of having duplicate index is extra overhead(extra page). So this means any insertion will take more time.
Little things like this get easily un-noticed.
So go today and find out how many duplicate indexes are in your databases :)
Have fun !
For example If I have a table say "Customer" and define one Non clustered Index on FirstName and then I define another index on FirstName and LastName then Firstname appears twice and the first Index can be called redundant and is not required.
Disadvantages of having duplicate index is extra overhead(extra page). So this means any insertion will take more time.
Little things like this get easily un-noticed.
So go today and find out how many duplicate indexes are in your databases :)
Have fun !
No comments:
Post a Comment