Description:
Since the same query may be executed using different plan, (depends on parameters values,
server settings, engine statistics, index availability, etc):
It would be nice to have track of all possible canonical execution plans: e.g. have
option to show in 'Browse Queries' grouping by (canonical query, execution plan), e.g.
| Query |Plan | Max |
|--------------------------+-----+-----+---
|select * from t where a=? | all | 2.7 |...
|select * from t where a=? | ref | 1.3 |...
....
This will give advantage, like:
1. compare effectiveness of certain plans
2. see effect of introducing new indexes
3. see when execution plan changed (first appeared, etc)
How to repeat:
n/a
Suggested fix:
n/a
