Re: Please help with performance problem

Gena,

I believe your updates and inserts are slowing you down because of the indexes.  If these are on-line, the data has to be inserted into the table AND a rowid inserted into the index. Also, If your're doing a lot of inserts and updates, are you analyzing your indexes regularly so the optimizer has good data to work with ? Also, if possible, consider the complete reload and index rebuild every few months. The reload should give you better data compaction along with fresh indexes.

Cliff Received on Sat Nov 22 1997 - 00:00:00 CST