db stat warnings

[Former Member]

Hi,

we have scheduled Check and Update optimizer daily.

Now it shows me following warning messages.

BR0988W Bitmap index /BI0/F0AFSD_C01~09 selected for checking statistics - please activate the monitoring attribute for table SAPBWD./BI0/F0AFSD_C01

BR0986W Index SAPBWD./BI0/IMATERIAL~0 is unbalanced - please rebuild the index

SO can any body tell me

1. how to activate monitoring attribute for table.

2. How to rebuild the index.

What is the use of running this update stats daily.I think it will improve the performance.

Pls help...

Regards,

viren.

[Former Member]

Ans1: go to oracle prompt sqlplus /nolog

conn /as sysdba

and issue

ALATER TABLE <tablename> MONITOR;

Ans2: To rebuild index, runreport RSORAANA.

SA38 --> RSORAANA, Here u can mention index name and select rebuild radio button.

Naresh