select table 'NAST' is very slowly

[Former Member]

Dears,

There is a background job running very slowly, Abaper debuged  that found it is very slow when select table 'NAST' in program, detail sentence as below:

SELECT objky
kschl
datvr
uhrvr
usnam
FROM nast
INTO TABLE i_nast
FOR ALL ENTRIES IN i_objk
WHERE objky EQ i_objk-objky
and KSCHL EQ 'ZDOC' .

but in the test system it runs very fast, the NAST table data is 49000000 entries in production system and 44000000 in test system.

we have done the update statistics  for this table and implement SAP Note 1020260 , but performance is still very slow .

Could you please help give any idea ?

Thanks,

Michael

[madasamy_arunachalam]

Hi

Which program or report  or transaction involved with NAST table ?,  found few oss notes with few reports for NAST table,,

Check the below note is in help ?

1798570 - Performance improvement for report RWTYARCH01 with NAST

Regards

Swami

[Sriram2009]

Hi Michael

Could you enable the ST12 trace, check the ABAP & DB usage. is this any index is missed

refer the SCN link http://scn.sap.com/docs/DOC-44143

BR

SS

[Former Member]

Hi SS,

We have done that in ST12 and found the result is also found the table NAST query is very slow.

We export the tabel NAST from production system to test system, and then perform the 'update statistics' for it , the test result is very fast, but acctually we also done the 'update statistics' in production system, but it still run very slow.

Thanks,

Michael