[FR: 12 Beta] - Re-order Missing Index columns in Perf Dash

If you select * from sys.dm_db_missing_index_details, you'll get equality_columns, inequality_columns, included_columns in that order.

In the Perf Dashboard they're re-ordered Inequality, Included, Equality. To me, it feels like the order given by the sys.dm query would be preferred viewing as you're likely to include equality columns first, right?

Or at least give us a way to re-arrange them the way we want and save that order.. it doesn't seem I can do that as of now.

Thank you. You're correct it's not possible currently to rearrange columns on the Missing Indexes tab in the Perf.Monitor and save them.

Just in case, if you use that report frequently, in v12 you can create new report with the columns you need and the order you prefer. And if it's saved to the right location, it will magically appear in context menus and can be run with two clicks. Creating such report is very easy, in the simplest case, it's like

Right-click in DB Explorer, in the right-click menu select Reports -> New Report...
click Next
Enter name Missing Indexes and paste select * from sys.dm_db_missing_index_details
click Next
select Table template
in the Page Options section choose Fit Data
click Generate
If you don't like what you see, change it as needed
Click Save and save it to %APPDATA%\SQL Assistant\Reports\SQL Server\Missing Indexes.sarpt

Now you have this "Missing Indexes" in the Reports sub-menu

Thanks. I'll look at the report, but ideally I'd just like the Missing Indexes part of the perf dash just re-order the columns so they match the sys.dm_db_missing_index_details view more closely, prioritizing the equality columns over inequality and included.

Noted. Thank you.

	Mindflux wrote:
	Thanks. I'll look at the report, but ideally I'd just like the Missing Indexes part of the perf dash just re-order the columns so they match the sys.dm_db_missing_index_details view more closely, prioritizing the equality columns over inequality and included.

+1, if that counts.

The report is great, but it is, after all, "just" a report. The dashboard is a much more capable tool when it comes to analyzing/solving the problem.

I can confirm the change in column ordering on Missing Indexes tab is going to make to 12.0 release.