data-konzept

'The missing index feature has the following limitations:

• It is not intended to fine tune an indexing configuration.

• It cannot gather statistics for more than 500 missing index groups.

• It does not specify an order for columns to be used in an index.

• For queries involving only inequality predicates, it returns less accurate cost information.

• It reports only include columns for some queries, so index key columns must be manually selected.

• It returns only raw information about columns on which indexes might be missing.

• It does not suggest filtered indexes.

• It can return different costs for the same missing index group that appears multiple times in XML Showplans.

• It does not consider trivial query plans.

The following sections provide more information about these limitations.'...

https://technet.microsoft.com/en-us/library/ms345485(v=sql.105).aspx