On 8/11/06, thomasjd@xxxxxxxxxxxxx <thomasjd@xxxxxxxxxxxxx> 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
