The installation routine automatically analyzes the database schema. It is highly recommended to do an analyze periodically.
To do this task, issue the following command from within SQL*Plus as user SYSTEM:
Execute DBMS_STATS.GATHER_SCHEMA_STATS ('M_SYS','COMPUTE');
You can use a script to perform this task. This script is called 5th_analyze.sql.
Smart Materials has been tested using the Oracle cost-based optimizer mode.