Hi All,

We have few queries whose performance gets enhanced by creating an index on a particular table. But how to asses whether the overall performance of the application has increased in general. As addition of the new index may cause slow updation on that column. Is there any rule of thumb for determining the same?

Please give your inputs.

Regards

Deepak

Oracle LazyDBA home page