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 |
|
yomi
Starting Member
25 Posts |
 Posted - 2013-02-13 : 02:11:07
|
| I have a table and i am created 10 indexes on that is it slow down my performance.Yogesh |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2013-02-13 : 03:27:13
|
| Usually Indexes will improve the performance of a select Query, where it is properly used.Un wanted indexes in a table will affect the performance of insert/update/delete Queries and also memory usage is high.Senthil Kumar C------------------------------------------------------MCITP - Database Administration SQL SERVER 2008MCTS - Database Development SQL SERVER 2008 |
 |
|
|
yomi
Starting Member
25 Posts |
Posted - 2013-02-13 : 03:45:04
|
| How i know which indexes are unwanted?Yogesh |
|
|
|
|
|
|
Database Indexing