Calculating impact of indexes for DML
- From: rjamya <rjamya@xxxxxxxxx>
- To: Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 25 Jun 2009 04:59:17 -0400
Hi all,
Is it possible to gauge/capture impact of having (a bit too many) indexes on
tables for DML operations? I know one can always drop and measure, but
outside of that are there any other methods? This relates to DW and staging
environment so multi-million row inserts do happen, db is 10203. I am trying
to set-up a test env but it is going to take time.
Many thanks in advance
-----
Best regards
Raj
Other related posts: