how to build statistics for a table, its urgent, points will be rewarded

[Former Member]

Hi friends,

I want to create a statistics for MSEG table in production server, because its not up to date.

Total no. of entries available in table is 2,30,000.

My O/S windows2003 (cluster)/oracle9.2/ ECC 5.

I need a step by step procedure to build or create statistics using DB20.

Regards,

s.senthil kumar

[stefan_koehler]

Hello Senthil,

just call transaction DB20 -> fill the field table with MSEG -> Statistics -> Create statistics

After that you can check the statistic via DB14 -> BRConnect

If you do this via DB20 the following command is executed in the background:

brconnect -u / -c -f stats -o SAPSR3 -t MSEG -f allsel,collect,keep

Regards

Stefan

[Former Member]

Hi stefan,

Thanks 4 ur reply.

I need some more clarification on db20.

Wt are the values I have to give on following fields.

New method and new sample size.

anyfields or chek box I need to fill before create new statistics?

My current screen values on following fields.

new method = 'C'. new sample size = ' '.

old method = 'C'. old sample size = ' '.

Old Number 5,965 Deviation Old -> New 3,669

New Number 24,834 Deviation New -> Old 97-

Inserted Rows 0 Percentage Too Old 0

Changed Rows 0 Percentage Too Old 0

Deleted Rows 0 Percentage Too New 0

Use A

Active Flag A

Analysis Method C

and history check box is marked.

Can I run DB20 while server is running or at peak time?

Regards,

s.senthil kumar

[stefan_koehler]

Hello,

> anyfields or chek box I need to fill before create new statistics?

No, just enter the table name press enter and then go to "Statistics -> Create statistics".

SAP has its own logic how the statistics are gathered:

http://help.sap.com/saphelp_nw70/helpdata/en/f4/81e93a637bfd70e10000000a11402f/content.htm

> Can I run DB20 while server is running or at peak time?

Yes you can run it while the server is running..

But think about it.. the new statistics are valid for new parsed statements only.. you can invalidate the old references in the shared pool or you can just wait until they are aged out and reparsed.

Regards

Stefan

[Former Member]

Hello Senthil,

You can also run Check and Update statistics operation for all tables through transaction DB13 which will automatically take care of all tables. You must maintain this tasks on weekly basis in Production environment.

Regards,

RR

Reward points if useful