Re: Performance effect of adding a new index

> How much do you think adding this index effect the general performance of
> this database?

You should choose your indexes carefully according to the kind of queries which will be run against the table.

At the risk of over-simplifying the matter or making assumptions about your database, in most cases the lack of a needed index is likely to have a far more detrimental effect on SELECTs than the presence of it will have on DML.

> What can I do to minimize the performance effect?

Since you are not using RAID, spread your various Oracle objects out over as many disks as possible according to load. But to say any more than that requires a detailed knowledge of how your database is used - and for you to gain an understanding of the many different aspects of performance tuning.

You could try putting the table and its indexes on separate disks but as yas has said at the rates you're talking about it's hardly going to be an issue and besides to take such a simplistic view could be dangerous. Received on Wed Apr 11 2007 - 05:11:53 CDT