Hi,
I am using Oracle Enterprise Stage to load a few big database tables.
I am choosing Index = Rebuild options.
The table is being loaded in parallel, however, the indexes are not using the parallel functionaly, eventually taking more time.
Could anyone please suggest how to make DataStage EE rebuild indexes in parallel.
Thanks
Rahul
Index Rebuild Parallel
Moderators: chulett, rschirm, roy
This can be done in the following ways also.
1)
Load the entire data using WRITE METHOD in Oracle Enterprise stage .
Call the shell script in After Job subroutine , for re-building the indexes.
Note
Your shell script should contain ,connection script to the oracle environment and also alter index rebuild script.
2)
In the stage give NoLogging clause as 'TRUE' and Compute statistics as False in the job. Once job is completed compute the statistics.
3) Normally index rebuild will be slow than drop and re-create in multiple scenario, avoid using this option in the stage , have a separate script to do this task.
Dennison,
India.
1)
Load the entire data using WRITE METHOD in Oracle Enterprise stage .
Call the shell script in After Job subroutine , for re-building the indexes.
Note
Your shell script should contain ,connection script to the oracle environment and also alter index rebuild script.
2)
In the stage give NoLogging clause as 'TRUE' and Compute statistics as False in the job. Once job is completed compute the statistics.
3) Normally index rebuild will be slow than drop and re-create in multiple scenario, avoid using this option in the stage , have a separate script to do this task.
Dennison,
India.