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 |
|
swarnanp
Starting Member
2 Posts |
 Posted - 2005-02-28 : 03:33:30
|
| What are the disadvantages of using too many nonclustered indexes on a table apart from excessive use of storage and slo search? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-02-28 : 07:28:41
|
| You won't get a slow search from an index, quite the reverse. You will get slower INSERT, UPDATE, and DELETE performance because the indexes need to be updated during these operations. Index operations are also logged so your transaction log will grow as well. |
 |
|
|
|
|
|
Non clustered Indexes