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 |
|
opi
Starting Member
29 Posts |
 Posted - 2009-05-11 : 03:43:44
|
| Hello everyone,I ran performance dashboard on my sql server and it suggest several missing indexes. Several are based on the same table with different columns. Is it advisable to create all these missing indexes? Or just the ones I think are most necessary?Thanks in advance |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2009-05-11 : 07:42:05
|
| Follow what microsoft explained in white paperhttp://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/SQL2005DTA.doc |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-05-11 : 22:32:12
|
| Run the execution plan and see the cost associated and analyze the performance after implementation. |
|
|
|
opi
Starting Member
29 Posts |
Posted - 2009-05-12 : 03:17:43
|
| How can I run the execution plan for a proposed index? |
|
|
|
|
|
|
What to do with suggested missing indexes