We have a table wich increases by 100 millions records/year. We put some indexes on this table to improve the performances of the queries(Select), but this table is considered as write-intensive(Insert,Update) as well. The two processus(reading and writing) are done simultaneously and we can not separate them (OLTP, Datawarehouse). Thousands of Insert statments are executed on the database and Oracle have to balance after each insert the B-Tree index causing an overhead.

Any suggestions.

Thanks in advance