Re: Running time of index rebuild
From: Øyvind Isene <oyvind.isene_at_gmail.com>
Date: Wed, 5 Jun 2013 19:10:24 +0200
Message-ID: <CAF+iMcFDxQF=KYNGg3xTp-vWA_VBvmxMQzE+UMDPtotKkUSEjg_at_mail.gmail.com>
Can you "refill" the test system several times with different sample sizes from prod and time the index rebuild there? Maybe you can fit the results to a function of table size and estimate the index rebuild for prod?
Date: Wed, 5 Jun 2013 19:10:24 +0200
Message-ID: <CAF+iMcFDxQF=KYNGg3xTp-vWA_VBvmxMQzE+UMDPtotKkUSEjg_at_mail.gmail.com>
Can you "refill" the test system several times with different sample sizes from prod and time the index rebuild there? Maybe you can fit the results to a function of table size and estimate the index rebuild for prod?
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 05 2013 - 19:10:24 CEST