Skip to Content
Former Member
Feb 25, 2011 at 05:48 PM

Update Stats & Rebuild Index


Hi All,

We are using ECC 6.0 installed on HP-Unix and Oracle 10g.

Update statistics job is running continously in our system but still in our Early Watch report we have got some tables to rebuild their indexes.

We expect that Update stats job shows us for tables whose indexes needs to be rebuild but still we have not got any table name in update stats job log to rebuild index.

So it seems that there is some creteria which Update stats job check to provide information to rebuid its index.

Please confirm that creteria and suggest how can we find out information for tables whose rebuild index is required to improve database performance.