I'm thinking of some UI improvements that could make all the difference for users trying to optimize low-performing queries.
We can organize the options to be grouped by their scope of effect, this will help users easily locate the options they may need to tune.
Since the options are a lot, we can add a filtering mechanism (i.e. string search or group\scope filtering) so the user can filter out the options he's not interested in. To provide more benefit than the grouping idea mentioned above, filtering may include keywords also and not just the option name, since the user may not be aware of the name of the option he's looking for.
I'm referring here to the metrics page and the query execution plan page that displays the overview section and major\minor fragments metrics. We can show hints for each metric such as:
- What does it represent in more details.
- What option\scope-of-options to tune (increase ? decrease ?) to improve the performance reported by this metric.
- May be even provide a small dialog to quickly allow the modification of the related option(s) to that metric