Run optimizer statistics for one table

[Former Member]

dear all,

i noticed an error in DB16 , that is <b>Missing Statistics for a table </b> SAPGRP.MC03BF0SETUP.

How to run/ generate the stats. for this table

[Former Member · Accepted solution]

3 ways:

1) brconnect -u / -f stats -t "table_name"

2) DB19 or 20 (can't remember the exact one) -- you'll figure it out

3) If you're hardcore, use Oracle's dbms_stats function...some nice functionality in there (i.e. export stats and bring them into another DB for testing)

[Former Member · Accepted solution]

Dear Somckit,

i could not run the above mentioned steps. it s not accepting the table name.

Actually.. This is the table where BW extracts data.

and it is a kind of SETUP TABLE of r/3 production seever.

Thank u.

[former_member204746 · Accepted solution]

at OS level:

brconnect -c -u / -f stats -t SAPGRP.MC03BF0SETUP

[Former Member · Accepted solution]

Can you post the error?

You may need to quote the table name.

[Former Member · Accepted solution]

Dear Somckit

here is the error msg. from DB16.

Description Table: SAPGRP.MC03BF0SETUP # Table or index has no optimizer

Correction Type D

Corrective Action Collect optimizer statistics

Check Log /oracle/GRP/sapcheck/cdwqhqnz.chk

Single Messages

No. Description

1 Table: SAPGRP.MC03BF0SETUP # Table or index has no optimizer statistics

2 Table: SAPGRP.MC03BX0SETUP # Table or index has no optimizer statistics

3 Table: SAPGRP.MC03UM0SETUP # Table or index has no optimizer statistics

4 Index: SAPGRP.MC03BF0SETUP~0 # Table or index has no optimizer statistics

5 Index: SAPGRP.MC03BX0SETUP~0 # Table or index has no optimizer statistics

6 Index: SAPGRP.MC03UM0SETUP~0 # Table or index has no optimizer statistics

Thank u.

[Former Member · Accepted solution]

Sorry, I meant the error from the brconnect run.

That is what's failing right?

At this point, I would just use the DB20 tcode...it will be much faster...

[Former Member · Accepted solution]

Thank u Somickit,

problem solved... with transaction DB20.