Use sp_BlitzIndex
to find problem queries and stats on existing indexes. Info Here
Includes vs Index Column
Includes do not sort. Examples
This index
|
|
Is equivalent to this query
|
|
This index
|
|
Is equivalent to this query
|
|
Enable Statistics when testing
Always enable IO Statistics and CPU Statistics when testing to see the impact your changes are making.
|
|
Use Statistics Parser to parse the output for better formatting if creating reports.