Table issue - Takes long time for processing - No data in the table

[m_aravindan]

Hi ,

There is a issue with a standard table. The table is not having any data, but still  it takes long time to process a delete statement.

When I checked for number of entries in SE11 , it returned as no entry’s. but for checking number

of entry’s , it took around 20 seconds to process.

Suggest your valuable thoughts on this.

Best Regards

Aravindan M

[former_member222232]

Hello Aravindan,

Normally, These kind of performance issues on table is improved when its statistics are update. Check for that table stats and update it and try again. That would help.

Thank you,

Sree.

[pasumpon_karuppaiah]

Hi Aravindan ,

I had the same issue, De Org of the table  solved the issue.

Best Regards

Pasumpon

[Sriram2009]

Hi Aravindan

In which standard table name your are having performance issue? during the deletion time what is the over all system usage? could you tell in detail

BR

SS

[m_aravindan]

Hi Sriram,

GRACROLEACTVl   IS the table name.

The table is not having any data.

during execution of the program ,it takes around 2 minutes to execute that particular

delete statement. For other delete statements it executes normally.

BR

Aravindan

[former_member242544]

Hi Aravindan,

The TRUNCATE TABLE statement is usually faster than removing all the rows with DELETE statement, because TRUNCATE ignores table dependencies (triggers, indexes, etc...) and there is no WHERE statement to check.  TRUNCATE removes all rows of the table, and also reassigns the empty extents to the freespace, so the table size should reduce.

You can simply use TRUNCATE TABLE GRACROLEACTVl;

regards, P. Mihálffy

[Sriram2009]

Hi Aravindan

Could you check this SAP Note 1873361 for your performance issue

BR

SS