| TableName |
AssocWaE |
| Unique |
YES |
| IndexType |
NON-CLUSTERED |
| Key Type |
PrimaryKey |
| DDL Code |
|
| ColumnName |
Sort Order |
| wfid |
Ascending |
| evid |
Ascending |
| STORAGE OPTION |
STORAGE VALUE |
| TABLESPACE |
|
| PCTFREE |
|
| MINEXTENTS |
|
| MAXEXTENTS |
|
| INITIAL |
|
| NEXT |
|
| PCTINCREASE |
|
| INITRANS |
|
| MAXTRANS |
|
| NO SORT |
NO |
| TYPE |
|
| BYTE ORDER |
|
| LOGGING |
|
| PARALLEL |
NO |
| PARALLEL DEGREES |
|
| PARALLEL INSTANCES |
|
| FREELISTS |
|
| FREELIST GROUPS |
|
| BUFFER POOL |
|
| Name |
Datatype |
Value Override |
Default Value |
Description |
| TableName |
Filename |
| Unique |
YES |
| IndexType |
NON-CLUSTERED |
| Key Type |
PrimaryKey |
| DDL Code |
|
| ColumnName |
Sort Order |
| fileid |
Ascending |
| STORAGE OPTION |
STORAGE VALUE |
| TABLESPACE |
|
| PCTFREE |
|
| MINEXTENTS |
|
| MAXEXTENTS |
|
| INITIAL |
|
| NEXT |
|
| PCTINCREASE |
|
| INITRANS |
|
| MAXTRANS |
|
| NO SORT |
NO |
| TYPE |
B-Tree |
| BYTE ORDER |
Forward |
| LOGGING |
Logged |
| PARALLEL |
NO |
| PARALLEL DEGREES |
|
| PARALLEL INSTANCES |
|
| FREELISTS |
FreeLists |
| FREELIST GROUPS |
FreeList Groups |
| BUFFER POOL |
|
| Name |
Datatype |
Value Override |
Default Value |
Description |
| TableName |
Filename |
| Unique |
NO |
| IndexType |
NON-CLUSTERED |
| Key Type |
Index |
| DDL Code |
|
| ColumnName |
Sort Order |
| dfile |
Ascending |
| STORAGE OPTION |
STORAGE VALUE |
| TABLESPACE |
|
| PCTFREE |
|
| MINEXTENTS |
|
| MAXEXTENTS |
|
| INITIAL |
|
| NEXT |
|
| PCTINCREASE |
|
| INITRANS |
|
| MAXTRANS |
|
| NO SORT |
NO |
| TYPE |
B-Tree |
| BYTE ORDER |
Forward |
| LOGGING |
Logged |
| PARALLEL |
NO |
| PARALLEL DEGREES |
|
| PARALLEL INSTANCES |
|
| FREELISTS |
FreeLists |
| FREELIST GROUPS |
FreeList Groups |
| BUFFER POOL |
|
| Name |
Datatype |
Value Override |
Default Value |
Description |
| TableName |
Subdir |
| Unique |
YES |
| IndexType |
NON-CLUSTERED |
| Key Type |
PrimaryKey |
| DDL Code |
|
| ColumnName |
Sort Order |
| subdirid |
Ascending |
| STORAGE OPTION |
STORAGE VALUE |
| TABLESPACE |
|
| PCTFREE |
|
| MINEXTENTS |
|
| MAXEXTENTS |
|
| INITIAL |
|
| NEXT |
|
| PCTINCREASE |
|
| INITRANS |
|
| MAXTRANS |
|
| NO SORT |
NO |
| TYPE |
B-Tree |
| BYTE ORDER |
Forward |
| LOGGING |
Logged |
| PARALLEL |
NO |
| PARALLEL DEGREES |
|
| PARALLEL INSTANCES |
|
| FREELISTS |
FreeLists |
| FREELIST GROUPS |
FreeList Groups |
| BUFFER POOL |
|
| Name |
Datatype |
Value Override |
Default Value |
Description |
| TableName |
Waveform |
| Unique |
NO |
| IndexType |
NON-CLUSTERED |
| Key Type |
Index |
| DDL Code |
|
| ColumnName |
Sort Order |
| datetime_on |
Ascending |
| STORAGE OPTION |
STORAGE VALUE |
| TABLESPACE |
|
| PCTFREE |
|
| MINEXTENTS |
|
| MAXEXTENTS |
|
| INITIAL |
|
| NEXT |
|
| PCTINCREASE |
|
| INITRANS |
|
| MAXTRANS |
|
| NO SORT |
NO |
| TYPE |
B-Tree |
| BYTE ORDER |
Forward |
| LOGGING |
Logged |
| PARALLEL |
NO |
| PARALLEL DEGREES |
|
| PARALLEL INSTANCES |
|
| FREELISTS |
FreeLists |
| FREELIST GROUPS |
FreeList Groups |
| BUFFER POOL |
|
| Name |
Datatype |
Value Override |
Default Value |
Description |
| TableName |
Waveform |
| Unique |
NO |
| IndexType |
NON-CLUSTERED |
| Key Type |
Index |
| DDL Code |
|
| ColumnName |
Sort Order |
| datetime_off |
Ascending |
| STORAGE OPTION |
STORAGE VALUE |
| TABLESPACE |
|
| PCTFREE |
|
| MINEXTENTS |
|
| MAXEXTENTS |
|
| INITIAL |
|
| NEXT |
|
| PCTINCREASE |
|
| INITRANS |
|
| MAXTRANS |
|
| NO SORT |
NO |
| TYPE |
B-Tree |
| BYTE ORDER |
Forward |
| LOGGING |
Logged |
| PARALLEL |
NO |
| PARALLEL DEGREES |
|
| PARALLEL INSTANCES |
|
| FREELISTS |
FreeLists |
| FREELIST GROUPS |
FreeList Groups |
| BUFFER POOL |
|
| Name |
Datatype |
Value Override |
Default Value |
Description |
| TableName |
Waveform |
| Unique |
YES |
| IndexType |
NON-CLUSTERED |
| Key Type |
PrimaryKey |
| DDL Code |
|
| ColumnName |
Sort Order |
| wfid |
Ascending |
| STORAGE OPTION |
STORAGE VALUE |
| TABLESPACE |
|
| PCTFREE |
|
| MINEXTENTS |
|
| MAXEXTENTS |
|
| INITIAL |
|
| NEXT |
|
| PCTINCREASE |
|
| INITRANS |
|
| MAXTRANS |
|
| NO SORT |
NO |
| TYPE |
B-Tree |
| BYTE ORDER |
Forward |
| LOGGING |
Logged |
| PARALLEL |
NO |
| PARALLEL DEGREES |
|
| PARALLEL INSTANCES |
|
| FREELISTS |
FreeLists |
| FREELIST GROUPS |
FreeList Groups |
| BUFFER POOL |
|
| Name |
Datatype |
Value Override |
Default Value |
Description |