Another update! I was triggered by the Question of the day
can a CTE be used in a view
. (The answer is yes 😀 )
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 :w00t:
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)
The best things in life are the simple things