Hi,

Is there a way to change or optimize updating of global indexes in Oracle 9i.

I have a DDL statement which executes as a part of batch job for 2-3 hours.
How do I change this to work better? The table_1 has partition and indexes on it.

The DDL statement is:

Code:
ALTER TABLE table_1 TRUNCATE PARTITION partition_name UPDATE GLOBAL INDEXES
Thanks.