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.
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.
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 |
Siebel Analytics Performance Tuning Guide Published: 18 April 2003 |