Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

create new CBO statistics for the tables

Dear All,

I am facing bad performance in server.In SM50 I see that the read and delete process at table D010LINC takes

a longer to create new CBO statistics for the tables D010TAB and D010INC. Please suggest.



Former Member

Hi Kumar,

i think D010LINC is only a typo, the table is D010INC without the L.

Ok, you call tx db20, insert the table name and then refresch the screen. Then you the actual values of the statistics.

In the menu bar "Statistics" -> "Create Statistics" -> "Yes" at the start operation window.

Then you come back to the db20 with "operation started" in the status line. Ok, there is no message when the operation is ended.

So try to refresh the screen and after a while you see the new statistic values.



0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question