Another update! I was triggered by the Question of the day
can a CTE be used in a view
. (The answer is yes :-D )
So I moved the select part to a CTE and did the calculation afterwards.
This results in a cleaner code and as a bonus the subtree cost is much lower
Also added column pressure
This column says something about how frequent this index is updated, compared to the size of the index. The calculation is: (hits-updates) / size of index.
A general rule: a high pressure means a lot of updates (update overhead).
For example: if your indexsize = 0MB and the pressure is high, it's probably a temporary table.
Till the next update! (waiting to approve this version)
WilfredThe best things in life are the simple things