SE16 - Long time executing table JCDS

[Former Member]

Hi,

I need to get values from table JCDS. I executed both ways foreground and background from SE16. However, it took me 20minutes to populate my values for a day time frame.

How can i increase the execution time? If its a program, I can tune, but if for direct execution from SE16,what can I do?

I do not have issues with other tables only jor JCDS.

Appreciate your help and feedback.

Thanks,

SS

Edited by: shafinaz syed on Dec 30, 2009 5:43 AM

[Former Member · Accepted solution]

Hello,

If you plan on doing queries of JCDS based on date you'll need to weigh the value of creating a secondary index. The new index will take more space but will speed up queries based on UDATE. In my experience it's a necessary evil, everyone always wants to report on status changes by date and time. Figure you'll increase the size of the table by 50 to 100% if you add an index.

Regards,

Michael

[Former Member · Accepted solution]

Thanks