?
Solved

missing index for specific qurey or stored proc in sqlserver

Posted on 2009-12-16
2
Medium Priority
?
355 Views
Last Modified: 2012-05-08
Hi,

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.

Thanks
dinesh
0
Comment
Question by:chandradineshbabu
2 Comments
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 2000 total points
ID: 26069051
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

DBCC FREEPROCCACHE;
DBCC DROPCLEANBUFFERS;

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

Author Closing Comment

by:chandradineshbabu
ID: 31667122
it is good answer i got it
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

850 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