Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide > Administering and Troubleshooting the Siebel Data Warehouse > Optional Customization Procedures >
Improving Performance of Full_Load_Siebel_DW
To improve the performance for the Full_Load, drop and recreate the query indexes. The query indexes that are used for analysis purposes can be dropped and recreated before and after the full load workflow.
To drop the indexes before running the full load, use ODBCSQL utility and the file drop_query_indexes.sql found in the dwrep folder to drop the indexes. Usage:
c:\sea700\dwdb\bin\odbcsql /s [ODBCName] /u [TableOwnerName] /p [TableOwnerPassword] /l [LogFileName] /a /c "--" c:\sea700\dwdb\dwrep\drop_query_indexes.sql
where ODBCName is the ODBC Entry created for the Siebel Data Warehouse. Use the Siebel-provided ODBC drivers or native ODBC database drivers.
Table 23 lists the flags used in the odbcsql command.
To recreate indexes after completing the Full Load, use the ddlimp utility found in the \dwdb\bin folder.
The usage of ddlimp is shown in the following example:
c:\sea700\dwdb\bin\ddlimp /u [TableOwnerName] /p [TableOwnerPassword] /c [ODBCName] /G SSE_ROLE /f c:\sea700\dwdb\bin\dwrep\ddlsme.ctl /b [TableSpaceName] /x [IndexSpaceName]
where ODBCName is the ODBC Entry created for the Siebel Data Warehouse. Use the Siebel-provided ODBC drivers or native ODBC database drivers.
Table 24 lists the flags used in the ddlimp command.
This utility creates the indexes in a single tablespace as specified above.
NOTE: In addition to reading this section, you should also see Technical Note 406, located on SupportWeb.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide Published: 09 September 2004 |