Repolulating the tables with multi-million rows for reduced redo logs

[vnktummala]

Thanks PAVB.

Don't we need APPEND to realize the affect of nologging.

Are you saying Reuse Storage is not benefiting the performance here. With Truncate the HWM should come down and append will insert data from lowered HWM but will not have to expand the TS storage as it fills multi-million rows.

APPEND use direct path and appends the data after the HWM.

Truncate with reuse storage would not bring down HWM. So not recommended to use when you are using APPEND hint.

Thanks,