This table maintains application group composite indexes
on application group fields.
Table 1. Application group composite index table
(ARSAGINDEX)
| Column Name |
Data Type |
Description |
| agid |
INTEGER |
Application group identifier |
| iid |
SMALLINT |
Index identifier |
| type |
INTEGER |
Application group identifier |
| sort_order |
SMALLINT |
Specifies the order of the application group
fields |
| ag_fld |
SMALLINT |
Application group field identifier |
| sort_type |
CHAR(1) FOR BIT DATA (Db2®), BINARY(1) (SQL Server), RAW(1)
(Oracle) |
Specifies that index entries should be kept
in ascending or descending order of the column values |
Table 2. Indexes for application group
composite index table (ARSAGINDEX)
| Index name |
Columns in index |
Type of index |
| arsagindex_idx |
agid |
Cluster index for Db2; Index for Oracle and SQL Server |