Calculating impact of indexes for DML

From: rjamya <>
Date: Thu, 25 Jun 2009 04:59:17 -0400
Message-ID: <>

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

-- Received on Thu Jun 25 2009 - 03:59:17 CDT

Original text of this message