missing index for specific qurey or stored proc in sqlserver

Posted on 2009-12-16
Last Modified: 2012-05-08

I want a query for missing index on given  specific query or sp .
if  i enter missing index DMV ,it is giving missing index information
for all the objects in the memory since server was started
that is available in BOL.

Question by:chandradineshbabu
    LVL 57

    Accepted Solution

    Hope you would have used the below one for finding Missing index information

    SELECT *
    FROM sys.dm_db_missing_index_details

    >> it is giving missing index information for all the objects in the memory since server was started

    To find out only for your query or stored procedure, you can run this one


    Now run your query or Stored proc and then the Missing index details DMV's to get Missing index only for your query..

    Author Closing Comment

    it is good answer i got it

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now