Calculating impact of indexes for DML

From: rjamya <rjamya_at_gmail.com>
Date: Thu, 25 Jun 2009 04:59:17 -0400
Message-ID: <9177895d0906250159j1d47df27rf1f05277bc6a1c54_at_mail.gmail.com>



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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jun 25 2009 - 03:59:17 CDT

Original text of this message