TD09X_COLLECT_TABLES_FOR_DELETION runtime

[Former Member]

Hi!

I noticed that activity TD09X_COLLECT_TABLES_FOR_DELETION runs for hours, more than 7h runtime. Is there a way to optimize this runtime?

In this case I'm running a time based reduction (ISOIL) with a previous shell system creation.

Can anyone of you check the runtime of the affected activity?

cheers,

Fernando

[amit_sharma36]

This is related to the secundary indexes that would be marked as UNUSABLE just after the system shell creation to optimize the runtime,
We should not put any index in this state for tables D*.

Please check the same. it would help you.

Regards,

Amit Sharma