D. Setting up the SQL Script File
The SQL script file is used to customize the tables that are used with the messaging infrastructure or business process infrastructure in the following cases.
-
When setting up RD area or table area (table space) in detail:
In HCSC server setup definition file, you can specify only the standard storage area. To specify a more detailed storage area, you must use SQL script file. Specific example is as follows:
-
Location directory information table and data transformation directory information table is a collective name for multiple tables. However, even if you use location-tbl-area property or cv-tbl-area property, you can set up only 1 RD area or table area (table space) for multiple tables.
-
You cannot set RD area or table area (table space) for PRIMARY KEY and CLUSTER KEY.
-
You can set only 1 RD area or table area (table space) for 1 table. (Split definition is not possible.)
-
-
When you want to improve search performance:
For the functions that are frequently used, indexes are set for columns according to the operations that are performed. For example, when the execution log information is displayed, an index can be set for the information that is used as the key values.