Question Re: SE16 - Long time executing table JCDS in Additional Q&A

SE16 - Long time executing table JCDS

Former Member — Wed, 30 Dec 2009 04:42:46 GMT

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,

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

Re: SE16 - Long time executing table JCDS

Former Member — Fri, 01 Jan 2010 13:54:46 GMT

Hi Syed,

It took me 20minutes to populate my values for a day time frame

Its depends on the values which you require from your database.If its huge, its consume much time.

But, you can trace this through ST05 tcode --

[Check this link.|http://naveenvishal.wordpress.com/2009/08/04/tracing-your-sql/]

Thanks & Regards,

Nagendra.

Re: SE16 - Long time executing table JCDS

Former Member — Sun, 03 Jan 2010 12:46:52 GMT

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

Re: SE16 - Long time executing table JCDS

Former Member — Mon, 04 Jan 2010 04:00:02 GMT

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?

Re: SE16 - Long time executing table JCDS

Former Member — Mon, 04 Jan 2010 07:15:15 GMT

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

Re: SE16 - Long time executing table JCDS

Former Member — Mon, 04 Jan 2010 13:48:21 GMT

Hi Syed,

This table is released by SAP without secondary indexes so, the only performatic way to access it is by primary key OBJNR, STAT, CHGNR. Do you really want whole data ? What are you trying to get from this table ?

Try to focus on the filter object number see below some samples:

. from 'OR000000100040' to 'OR000000102222'

. 'OR*'

. 'IE*'

. 'KS*'

this OR, IE, KS is the prefix according to the type of your object.

Another TIP, this table is the complete status, but for individual status you can use table JEST, both tables use OBJNR from table ONR00.

Of course you may check the database statistics (DB20/DB21), but maybe the problem belongs to the way you are trying to access it.

Regards, Fernando Da Ros

Re: SE16 - Long time executing table JCDS

Former Member — Mon, 04 Jan 2010 21:00:03 GMT

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

Re: SE16 - Long time executing table JCDS

Former Member — Wed, 24 Feb 2010 03:27:41 GMT

Thanks