SE16 - Long time executing table JCDS

[#1]

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]

Dear Syed.

In my system the table size is 135MB having 631789 rows. I am able to open table in 2 minutes with all rows.

Please go to table detail in db02 to optmize and execute the DBCC checktable.

Regards

Anwer Waseem

Edited by: Anwer Waseem on Jan 3, 2010 2:50 PM

[Former Member]

Hi Anwer,

The table size you mention refers to tablespace or table size for JCDS?

If its for JCDS, how can i check a size for a certain table?

[Former Member]

Hi Anwer,

I am using the ECC6 with SQL 2005 DB, you can check the table size in db02 and detailed analysis then you can evaluate further the table.

I believe, oracle DB having same option to optimize the table size and DB Check.

Regards

Anwer Waseem