Another update! I was triggered by the Question of the day

. (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)