| Author |
 Topic  |
|
|
viperbyte
Posting Yak Master
USA
101 Posts |
 Posted - 12/04/2012 : 12:27:02
|
Hello everyone.
When I look at an execution plan there's a message that reads:
"Missing Index (Impact 48.8021): Create NONCLUSTERED Index [<Name of Missing Index, sysname, >] ON [dbo.][tblClaimToBeEntered] ([ClaimKey])
So I create the index but I still get that message in the execution plan. I see the newly created index when I expand the table that it belongs to and click on indexs. Can someone please tell me what I'm doing wrong? |
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
viperbyte
Posting Yak Master
USA
101 Posts |
Posted - 12/04/2012 : 15:03:24
|
The execution plan is from a select * from aView statement. When I ran dbcc proccache there was a lot going on so for just in case I'll run the dbcc freeproccache command tommorow morning before everyone shows up.
I'll be subscribing to your blow for sure when I get home. |
 |
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
| |
Topic |
|
Why Do I keep Getting a Missing Index message?
