23 November 2009 00:49
ssqa.net
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..!
Filed under: sql server, index, dba, indexes, best practice, execution plan, feature, dmv, missing index
