demonstrated how bad HWM would be for FTS

have you compared the time needed for delete vs truncate?

if these tables are the statging tables, would it be faster/improved performance with we use NOLOGGING option on those tables since they do a massive INSERT and DELETE at the end of teir process???


thanks,

nologging only works for DIRECT INSERT, RTFM