CARIS HPD : Database Administration : Upgrading a Schema : Before Upgrading an HPD Schema : Optional Elements : Upgrade Optimization
 
Upgrade Optimization

The script setIndexTablespace.sql can be used to define the tablespace that new indexes are created in. It can also be run at any time that there is a noticeable loss in overall performance.