Per purpose of performance, How can I update the indexes or Statistics of the database? can I do the job in Oracle scope or BAAN provides the tool to do that in the name of Oracle? Where can I find out the document about such process if it has to use BAAN tool? Can BAAN automatize the process?

I don't know of a process from within Baan. You should do it on Oracle. Example of syntax:
analyse table tppmmmxxx compute statistics


Regards,
Eli Nager

With 10G release 2 (not sure about release 1) Oracle will create a dbms job which analyzes the tables between 22.00 and 06.00 and during weekends. Just check the last_analyzed column in dba_tables.

By using the Oracle method I have been able to remove my own job of analyzing the tables.

Regards,
Han

I'm running Oracle 9i and here is the job I run on weekends.

exec dbms_stats.gather_schema_stats(ownname => 'BAANDB', estimate_percent => 100, granularity => 'ALL', method_opt => 'FOR ALL COLUMNS SIZE 1',degree => NULL , options => 'GATHER', cascade => TRUE );

Refer to the Oracle documentation: A Practical Approach to Optimizer Statistics in Oracle Database 10g (http://www.oracle.com/technology/deploy/performance/pdf/PS_S961_273961_106-1_FIN_v2.pdf)