Re: howto disable index build before full load?

I'd drop and recreate the indexes.
If you're worried about object creation failures : Create a tablespace for just those indexes. Make it's default initial and next parameters the same, and pctincrease 0. Create the indexes (with UNRECOVERABLE or NOLOGGING). PARALLEL will make it faster but will give you more to go wrong. Give them the same storage parameters as your tablespace. Yes, I know that it's unnecessary to specify them again. I'm just paranoid.
This should remove any tablespace size/space fragmentation/rollback/redo worries.

Mike Hately

bmlam <bmlam_at_online.de> wrote in message news:38F89647.1218CC90_at_online.de...
> Here is the challenge:
>
> To speed up performance in loading data for a data warehouse
> application, we would like to the following in a PL/SQL
> package/procedure
>
> 1. truncate the table
> 2. "disable the build of indexes on the table"
> 3. insert load into the table
> 4. "enable the indexes"
>
> Step 1 4 are straightforward. Step 2 and 4 are more convoluted because
> the methods known to me would require to do the following with dynamic
> SQL
>
> 2. drop all the indexes
> 4. create the indexes with all the required parameters.
>
> For my taste, step 4 is too error prone bcos it requires putting too
> many logic into dynamic SQL statements that may go wrong during run
> time. So I am looking for a way that is more bulletproof. Any ideas?
>
Received on Mon Apr 17 2000 - 00:00:00 CDT