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 time.how to create new CBO statistics for the tables D010TAB and D010INC. Please suggest.

Regards,

Kumar

Former Member
replied

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.

regards

Kay

0 View this answer in context

Helpful Answer

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