Bookshelf Home | Contents | Index | Search | PDF

Siebel Analytics Performance Tuning Guide > The ETL Process > Drop and Recreate Indexes >

Split Index Script Files for Parallelism

---

Suppose Data Warehouse Inc. used the script Create_Rest_indexes.sql to create indexes using the session create_rest_indexes in Figure 14.

Figure 14. Create_Rest_indexes.sql

An administrator can potentially improve performance by splitting the .sql script in to three scripts:

Create_rest_indexes1.sql
Create_rest_indexes2.sql
Create_rest_indexes3.sql

To create the indexes in parallel

Create a new batch called CreateRestIndex.
Check the concurrent option.
Move the existing session CreateRestIndex into the newly crated batch.
Add two new sessions after the existing session (createRestindex).
Modify the post session properties to point to the new .sql script files.

Splitting the index scripts reduced the load time by roughly an hour and forty-five minutes. See Figure 15.

Figure 15. Split Index Scripts

Look for other opportunities to split these scripts into multiple parts as shown in the figure above so you can take advantage of processing the scripts in parallel.

Bookshelf Home | Contents | Index | Search | PDF