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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-18 : 22:18:58
|
tim writes "I have inherited a database which seems very liberal in the use of indexes. On some tables there are up to 9 indexes, several which are using varchars in composite indexes. I was alarmed when I saw the disk space usage of several of these indexes. The database has over 4000 indexes on 600+ tables. I may not have a call in reducing this, but is there a good rule of thumb on how many indexes to use, and at what point you actually incur so much overhead you lose performance gains by having the index?
thanks!" |
|
|
|
|
|
What is considered too many indexes?