create new CBO statistics for the tables
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.
Kay Kanekowski replied
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.