I have 2 indexes on a table. One of those indexes
has extents which keep increase until they fill up
the tablespace they are in. The table fills up
every day with stats and then most rows are
deleted. (summarized in another table)
So even though the rows are kept small the extents
of 1 index keep increasing. This index is based
on a field in the table which keeps incrementing
so some of the old rows in the table have old numbers.
Maybe the btree is unbalanced?
Oracle says the only way to solve this problem is
to drop the indexes and recreate them before the
tablespace fills up.
This is a pain however? Any better suggestions?