1
kudos
spam Kudos Remove

How fast you can obtain information about missing indexes? Its easy and quick!
published 796 days, 19 hours, 20 minutes ago posted by sasa 806 days, 3 hours, 42 minutes ago
Wednesday, December 02, 2009 7:39:50 PM GMT Monday, November 23, 2009 11:17:23 AM GMT
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...(read more)
category: News | clicked: 1 | | source: sqlserver-qa.net | show counter code
tags: best practice, dbas, DMV, Execution Plan, index hint, Indexes, Monitoring, Performance, SQL Server, view server state

No comments yet, be the first one to post comment.

To post your comment please login or signup