Index tablespace increasing...does Alter indexes rebuild help to reduce it??

[nabaig]

Yse, sure it will if there are a lot of deleted rows in the base table. In that case, there are holes in the index which can be compacted with a rebuild statement.

In 9i you could do an online rebuild of the index.

Nizar