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 |
|
viperbyte
Posting Yak Master
132 Posts |
 Posted - 2012-12-04 : 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
38200 Posts |
|
|
viperbyte
Posting Yak Master
132 Posts |
Posted - 2012-12-04 : 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
38200 Posts |
|
|
|
|
|
Why Do I keep Getting a Missing Index message?