Configure System Parameters > Configure Database Index Rebuilds
  
Version 9.2.00
Configure Database Index Rebuilds
In large environments, if report generation performance begins to degrade, database indexes can be built more frequently. The default is to rebuild indexes every 60 days.
Use the following procedure to configure the frequency of index builds in the system parameters.
1. Log on to the Portal Server as user aptare.
2. Enter the following command:
sqlplus portal/portal_password
3. Locate the default value.
SELECT param_value
FROM ptl_system_parameter
WHERE param_name=’DAYS_BETWEEN_INDEX_REBUILDS’;
4. Update the value for DAYS_BETWEEN_INDEX_REBUILDS in the system parameters.
UPDATE ptl_system_parameter set param_value=30 WHERE param_name=’DAYS_BETWEEN_INDEX_REBUILDS’;
commit;