<div>
thanks. Ya the include clause was different when i actually looked at the script. But I am not sure why DTA would put that one column on the include clause because I could create the same index making it a key column. It is not of the datatype not allowed by the key column, nor does it fulfil the index key size.<br />
<br />

</div>


thanks. Ya the include clause was different when i actually looked at the script. But I am not sure why DTA would put that one column on the include clause because I could create the same index making it a key column. It is not of the datatype not allowed by the key column, nor does it fulfil the index key size.



<div>
The leaf level of an index with the include column is a little bit smaller. &nbsp;I suppose that is why it suggested the include column instead of a key column.
</div>


The leaf level of an index with the include column is a little bit smaller.  I suppose that is why it suggested the include column instead of a key column.

<div>
<div class="content wysiwyg-content">
I had used dta for index suggestions and applied those suggestion.<br />
<br />
i run sp_helpindex[tablename] on one of my table and seems like dta had suggested indexes which are already there. as you can see in the screenshot i have different indexes created for same index_keys. Is it every time I run DTA, it suggests index even though the index is already created for those keys? <a href="https://filedb.experts-exchange.com/incoming/2010/09_w40/354016/Capture.PNG" target="_blank" title="Screenshot of sp_helpindex (27 KB)"><img alt="Screenshot of sp_helpindex" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2010/09_w40/800_354016/Capture.PNG" /></a>
</div>
</div>


Capture.PNG

I had used dta for index suggestions and applied those suggestion.

i run sp_helpindex[tablename] on one of my table and seems like dta had suggested indexes which are already there. as you can see in the screenshot i have different indexes created for same index_keys. Is it every time I run DTA, it suggests index even though the index is already created for those keys? 

SQL server 2005 DTA suggests Index with same index_keys multiple times?

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.