updating indexed table

[goodmans]

Hi Oracle gurus.

I need your suggessions on the below situation.

I have a table with 200 columns, 60m records

Columns
KEY -- indexed
C2 -- indexed
C3 -- indexed
C4 -- indexed
C5 -- partitioned
.
.
.
.
C200
DEL_FLG

Update Statement:
UPDATE TABLE SET DEL_FLG='Y' WHERE KEY=10000;

I guess by adding condition on partitioned column will increase the performance. Correct me if i am wrong.

I just want to know if the indexes on c2, c3, c4 degrades the perforamnce of the update operation or will they be ignored as they are not touched?.

Regards

Goodmans

 

[Dagon]

Are the indexes local or global ?

 

[goodmans]

local indexes.

Thanks

 

[Dagon]

For local indexes, I think it would improve performance to specify the partition because, otherwise, Oracle will have to scan through all the index partitions. If you are not updating the indexed columns or the partitioning column, then performance of the update should not be affected.