DBA Gurus,
I am responsibble for maintening Oracle Application [11.5.9] database [9.2.0.3]. As DBA I know when & how should we rebuild index. Can any body share their practices for rebuilding indexes reguraly. How much performance benefit we can get by rebuilding exercise especially when the rows in most tables are not deleted often. Some notes on Metalink say that index building is not really require unless there is bulk row deletes from table. And even that case we might consider reorganising table also.