Welcome to the world (new face) of Knowledge Sharing Network.
To track the older blog posts refer to our historical knowledge sharing site  and you will find this as your destination for SQL Server knowledge pool.

Follow SQLMaster on Twitter SqlServer-QA.net - Knowledge Sharing Network (@sqlmaster)

How fast you can obtain information about missing indexes? Its easy and quick! - SQL Server Knowledge Sharing Network (@sqlmaster)

How fast you can obtain information about missing indexes? Its easy and quick!

On the subject line the process to find the answer is not a short one!

By design SQL Server engine takes care when the query optimizer generates a query plan, it analyzes what are the best indexes for a particular filter condition. If the best indexes do not exist, the query optimizer generates a suboptimal query plan, but still stores information about these indexes. The missing indexes feature from 2008 version (in specific) enables you to access information about these indexes so you can decide whether they should be implemented. There are no special tools involved here and the missing index feature uses dynamic management objects and Showplan to provide information about missing indexes that could enhance SQL Server query performance. ...read more..!

 

Published Monday, November 23, 2009 12:49 AM by ssqa.net

Comments

No Comments