Siebel Analytics Performance Tuning Guide > The ETL Process >

Drop and Recreate Indexes

Siebel Systems recommends that you drop the indexes on the W_ tables before you load these tables, and then recreate the indexes after the load. This can reduce the time required to load the tables.

You can automate this process with batch files that can be attached to an Informatica session as a post-session-script. These scripts automatically drop the specified indexes before the session, and then recreates the indexes after the session loads the data. Each batch file executes an .sql file to drop or create the indexes.


 Siebel Analytics Performance Tuning Guide 
 Published: 18 April 2003