Re: Running time of index rebuild
Date: Wed, 5 Jun 2013 09:59:16 -0700 (PDT)
Message-ID: <1370451556.18166.YahooMailNeo_at_web121605.mail.ne1.yahoo.com>
You can't base it solely on size; it also depends upon how many columns are indexed as each requires a full table scan to gather data.
David Fitzjarrell
From: Ingrid Voigt <giantpanda_at_gmx.net> To: oracle-l_at_freelists.org
Sent: Wednesday, June 5, 2013 8:56 AM
Subject: Running time of index rebuild
Hi, does anybody know how the running time for index create or rebuilds
inOracle changes withnumber of lines / table size? I would expect O(n log
n)? We need a guesstimate for the time for a complete rebuild where the
test environment is considerably smaller: TEST: 19 mio rows / 16 GB / 15
minutes PROD: 894 mio rows / 725 GB / ??? Refilling test with complete
production data is not an option. I know that index rebuilds are not
usually necessary. In this case we need to gain enough space in the database
to last until the new SAN is usable, and 50 GB (as predicted by the segment
advisor) would be very helpful. My suggestion for the maintenance window
an prod would be 16 hours, do you have a better idea? Best regards
IngridVoigt
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 05 2013 - 18:59:16 CEST