Siebel Analytics Applications Installation and Administration Guide > DAC Quick Start > DAC Common Tasks >

Customizing Index and Analyze Table Syntaxes

The customsql.xml file, located in the SiebelAnalytics\DAC\CustomSQLs directory, contains the syntax for dropping and creating indexes and analyzing tables. You can edit the customsql.xml file to change the behavior of these operations.

To edit the Analyze Table syntax

1. Open the customsql.xml file located in the SiebelAnalytics\DAC\CustomSQLs directory.
2. Locate the Analyze Table syntax for the appropriate database type.

   For example, the syntax for an Oracle database is as follows:

   <SqlQuery name = "ORACLE_ANALYZE_TABLE" STORED_PROCEDURE = "TRUE">
   DBMS_STATS.GATHER_TABLE_STATS(ownname => '@TABLEOWNER', tabname => '%1', estimate_percent => 30, method_opt => 'FOR ALL COLUMNS SIZE AUTO',cascade => true )
   </SqlQuery>

3. Edit the syntax.

   For example, to gather statistics for only the indexed columns, edit the syntax as follows:

   <SqlQuery name = "ORACLE_ANALYZE_TABLE" STORED_PROCEDURE = "TRUE">
   DBMS_STATS.GATHER_TABLE_STATS(ownname => '@TABLEOWNER', tabname => '%1', estimate_percent => 30, method_opt => 'FOR ALL INDEXED COLUMNS',cascade => true )
   </SqlQuery>

   NOTE:  The variables @TABLEOWNER, %1, %2, and so on, will be substituted appropriately by the DAC when the statement is executed.

To edit the Create Index syntax

1. Open the customsql.xml file located in the SiebelAnalytics\DAC\CustomSQLs directory.
2. Locate the Create Index syntax for the appropriate database type, and edit the syntax.