SQL Server Knowledge Sharing Network (@sqlmaster) : best practice, indexhttp://sqlblogcasts.com/blogs/ssqanet/archive/tags/best+practice/index/default.aspxTags: best practice, indexenCommunityServer 2007.1 (Build: 20917.1142)How fast you can obtain information about missing indexes? Its easy and quick!http://sqlblogcasts.com/blogs/ssqanet/archive/2009/11/23/how-fast-you-can-obtain-information-about-missing-indexes-its-easy-and-quick.aspxMon, 23 Nov 2009 00:49:00 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:12579ssqa.net0http://sqlblogcasts.com/blogs/ssqanet/rsscomments.aspx?PostID=12579http://sqlblogcasts.com/blogs/ssqanet/archive/2009/11/23/how-fast-you-can-obtain-information-about-missing-indexes-its-easy-and-quick.aspx#commentsOn 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...(<a href="http://sqlblogcasts.com/blogs/ssqanet/archive/2009/11/23/how-fast-you-can-obtain-information-about-missing-indexes-its-easy-and-quick.aspx">read more</a>)<img src="http://sqlblogcasts.com/aggbug.aspx?PostID=12579" width="1" height="1">sql serverindexdbaindexesbest practiceexecution planfeaturedmvmissing index