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 |
|
b11091019
Starting Member
15 Posts |
 Posted - 2012-02-08 : 12:39:07
|
| Hi -- When I ask for an execution plan, I see a hilighted "missing index" line. If I hold my mouse over that, a box appears with a CREATE INDEX statement that would build the missing index.How can I copy that suggested CREATE INDEX statement to the clipboard or a new query so that I can work with it? |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-02-08 : 13:04:55
|
| Right click -> Missing Index Detailsp.s. It's a suggestion, not a directive. Don't assume that the suggested index is correct, ideal or necessary. It may be none of those.--Gail ShawSQL Server MVP |
 |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-02-08 : 13:05:16
|
If you right click and select the "Missing Index Details", you should be able to copy it. |
|
|
|
b11091019
Starting Member
15 Posts |
Posted - 2012-02-08 : 13:13:32
|
| Thanks! I missed the Missing Index Details! |
|
|
|
|
|
|
Getting create index statement from execution plan