Skip to Content
avatar image
Former Member

TD09X_COLLECT_TABLES_FOR_DELETION Performance

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Mar 25, 2013 at 06:27 AM

    Hello Fernando,

    Long runtime can be reduced by using proper secondary indexes of DD* tables.

    Please check if secondary indexes of these tables are getting used or not.

    Regards,

    Amit Sharma

    Add comment
    10|10000 characters needed characters exceeded