Re: Index Maintenance for DW environment

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 11 Aug 2006 15:25:59 +0100
Message-ID: <7765c8970608110725j7d060ea6p138e568d064e0863@mail.gmail.com>

On 8/11/06, thomasjd_at_insightbb.com <thomasjd_at_insightbb.com> wrote:
>
> Our shop is new to large-scale datawarehouse projects. We are finding our
> current index maintenance strategy for nightly jobs to be unworkable, as it
> consists of dropping all indexes before the nightly run, and building them
> anew after the run is completed, via large SQL scripts.
>

I am not a DW DBA. However it sounds at least possible to me that appropriate use of partitioning might be an option for you.

--
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Aug 11 2006 - 09:25:59 CDT