SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Why Do I keep Getting a Missing Index message?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

viperbyte
Posting Yak Master

USA
132 Posts

Posted - 12/04/2012 :  12:27:02  Show Profile  Reply with Quote
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
36597 Posts

Posted - 12/04/2012 :  14:31:52  Show Profile  Visit tkizer's Homepage  Reply with Quote
If it's a stored procedure, you could recompile it to see if it'll use the new index. If it's not, you could try freeing the procedure cache.

As far as what you are doing wrong, nothing really.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

viperbyte
Posting Yak Master

USA
132 Posts

Posted - 12/04/2012 :  15:03:24  Show Profile  Reply with Quote
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.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36597 Posts

Posted - 12/04/2012 :  15:31:44  Show Profile  Visit tkizer's Homepage  Reply with Quote
Recompile the view then.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000