"Abba" <SQL_H***@aaa.com> wrote in message
news:O1jH%23Mi9JHA.1492@TK2MSFTNGP03.phx.gbl...
> Hello,
>
> [sql2005]
> Do you know which feature of SQL gives an output like this:
> "Missing Index Details from ExecutionPlan1.sqlplan. The Query
> Processor estimates that implementing the following index could
> improve the query cost by 24.8260%. "
>
>
> TIA
> AbbA
>
>
>
>

"Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in
message news:ufm7$Oj9JHA.1340@TK2MSFTNGP05.phx.gbl...
> Can you explain what you mean by "which feature of SQL"?
> Also, where are you seeing these messages?
>
> As of SQL 2005, the optimizer can see if there are any indexes it feel
> could have helped for the query it optimizes. The information you can see
> in the missing indexes DMV's and also in the XML showplan. SSMS 2008 even
> show this in the graphical representation of the XML showplan.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
>
> "Abba" <SQL_H***@aaa.com> wrote in message
> news:O1jH%23Mi9JHA.1492@TK2MSFTNGP03.phx.gbl...
>> Hello,
>>
>> [sql2005]
>> Do you know which feature of SQL gives an output like this:
>> "Missing Index Details from ExecutionPlan1.sqlplan. The Query Processor
>> estimates that implementing the following index could improve the query
>> cost by 24.8260%. "
>>
>>
>> TIA
>> AbbA
>>
>>
>>
>>
>

"Abba" <SQL_H***@aaa.com> wrote in message
news:ugoJkmj9JHA.1340@TK2MSFTNGP05.phx.gbl...
> Tibor,
>
> A list of such suggestions were in the document submitted by an external
> consultant. I have never seen this and was curious as to how I can
> reproduce the same.
>
> How can I get to XML showplan in SQL2008?
>
> "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote
> in message news:ufm7$Oj9JHA.1340@TK2MSFTNGP05.phx.gbl...
>> Can you explain what you mean by "which feature of SQL"?
>> Also, where are you seeing these messages?
>>
>> As of SQL 2005, the optimizer can see if there are any indexes it feel
>> could have helped for the query it optimizes. The information you can see
>> in the missing indexes DMV's and also in the XML showplan. SSMS 2008 even
>> show this in the graphical representation of the XML showplan.
>>
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>>
>> "Abba" <SQL_H***@aaa.com> wrote in message
>> news:O1jH%23Mi9JHA.1492@TK2MSFTNGP03.phx.gbl...
>>> Hello,
>>>
>>> [sql2005]
>>> Do you know which feature of SQL gives an output like this:
>>> "Missing Index Details from ExecutionPlan1.sqlplan. The Query Processor
>>> estimates that implementing the following index could improve the query
>>> cost by 24.8260%. "
>>>
>>>
>>> TIA
>>> AbbA
>>>
>>>
>>>
>>>
>>
>
>