It is generally well known that indexes help a lot to speed up database queries (especially
SELECT but also
DELETE). It is less known, that indexes also have some disadvantages.
One of these disadvantages is, that indexes require space in memory and on disk. An other disadvantage of indexes is, that they slow down DML statements like
We often see at our customers that they do not realized this behavior. Now I found the time to show the impact of (too) many indexes graphically.