Running time of index rebuild
From: Ingrid Voigt <giantpanda_at_gmx.net>
Date: Wed, 5 Jun 2013 16:56:43 +0200 (CEST)
Message-ID: <trinity-b7f5ad9d-36b7-4336-8516-e3d16128d226-1370444203318_at_3capp-gmx-bs20>
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
Date: Wed, 5 Jun 2013 16:56:43 +0200 (CEST)
Message-ID: <trinity-b7f5ad9d-36b7-4336-8516-e3d16128d226-1370444203318_at_3capp-gmx-bs20>
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 regardsIngridVoigt
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 05 2013 - 16:56:43 CEST