I came across V$SEGMENT_STATISTICS dynamic view.
What statistic should I consider to tell if index block is being updated from time to time (on the contrary to scenario where index block is created once and it's only read since then.
I want to find out only the indexes that are updated. db block changes
as I understand it, does not distinguish insert/update/delete operations. Change is change and not update solely.
I just want to prepare list of indexes that can be compressed. As I understand if index is frequently modified over the time, maybe it's better not to put additional overhead as index compression. Does this make sense?
v$statname
. Index entries are never updated. An update on an entry is actually an insert + delete (mark deleted).