| BEAM_ALLOC.PK_BEAM_ALLOC |
| TableName | BEAM_ALLOC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| BEAM_ALLOC.PK_BEAM_ALLOC Index Columns |
| ColumnName | Sort Order |
| INSTR_ID | Ascending |
| FACIL_ID | Ascending |
| RUN_CYCLE_ID | Ascending |
| ALLOT_ID | Ascending |
| PRPSL_TYPE_ID | Ascending |
| BEAM_ALLOC.PK_BEAM_ALLOC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_OPER_TS |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | B-Tree |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | 1 |
| FREELIST GROUPS | 1 |
| Buffer Pool | DEFAULT |
| Index Compression | NO |
| BEAM_ALLOC.PK_BEAM_ALLOC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BEAM_ALLOC.PK_BEAM_ALLOC Bound Attachments |
| Name | Current Value |
| BEAM_ALLOC_ALLOT.PK_BEAM_ALLOC_ALLOT |
| TableName | BEAM_ALLOC_ALLOT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| BEAM_ALLOC_ALLOT.PK_BEAM_ALLOC_ALLOT Index Columns |
| ColumnName | Sort Order |
| ALLOT_ID | Ascending |
| BEAM_ALLOC_ALLOT.PK_BEAM_ALLOC_ALLOT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| BEAM_ALLOC_ALLOT.PK_BEAM_ALLOC_ALLOT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BEAM_ALLOC_ALLOT.PK_BEAM_ALLOC_ALLOT Bound Attachments |
| Name | Current Value |
| BEAM_ALLOC_DEF.PK_BEAM_ALLOC_DEF |
| TableName | BEAM_ALLOC_DEF |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| BEAM_ALLOC_DEF.PK_BEAM_ALLOC_DEF Index Columns |
| ColumnName | Sort Order |
| ALLOT_ID | Ascending |
| PRPSL_TYPE_ID | Ascending |
| BEAM_ALLOC_DEF.PK_BEAM_ALLOC_DEF Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| BEAM_ALLOC_DEF.PK_BEAM_ALLOC_DEF Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BEAM_ALLOC_DEF.PK_BEAM_ALLOC_DEF Bound Attachments |
| Name | Current Value |
| BES_INST_CAT.PK_BES_INST_CAT |
| TableName | BES_INST_CAT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| BES_INST_CAT.PK_BES_INST_CAT Index Columns |
| ColumnName | Sort Order |
| CAT_ID | Ascending |
| BES_INST_CAT.PK_BES_INST_CAT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| BES_INST_CAT.PK_BES_INST_CAT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| BES_INST_CAT.PK_BES_INST_CAT Bound Attachments |
| Name | Current Value |
| CNTRY.PK_CNTRY |
| TableName | CNTRY |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| CNTRY.PK_CNTRY Index Columns |
| ColumnName | Sort Order |
| CNTRY_ID | Ascending |
| CNTRY.PK_CNTRY Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_OPER_INDEX_TS |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | 1 |
| FREELIST GROUPS | 1 |
| Buffer Pool | |
| Index Compression | NO |
| CNTRY.PK_CNTRY Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| CNTRY.PK_CNTRY Bound Attachments |
| Name | Current Value |
| EMAIL_LOG.PK_EMAIL_LOG |
| TableName | EMAIL_LOG |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EMAIL_LOG.PK_EMAIL_LOG Index Columns |
| ColumnName | Sort Order |
| TEMPLATE_ID | Ascending |
| RUN_CYCLE_ID | Ascending |
| CUR_DTE | Ascending |
| EMAIL_ADDR | Ascending |
| EMAIL_LOG.PK_EMAIL_LOG Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EMAIL_LOG.PK_EMAIL_LOG Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EMAIL_LOG.PK_EMAIL_LOG Bound Attachments |
| Name | Current Value |
| EMAIL_PREV.PK_EMAIL_PREV |
| TableName | EMAIL_PREV |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EMAIL_PREV.PK_EMAIL_PREV Index Columns |
| ColumnName | Sort Order |
| TEMPLATE_ID | Ascending |
| SEQ_ID | Ascending |
| EMAIL_PREV.PK_EMAIL_PREV Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_ADMIN |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | B-Tree |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | DEFAULT |
| Index Compression | NO |
| EMAIL_PREV.PK_EMAIL_PREV Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EMAIL_PREV.PK_EMAIL_PREV Bound Attachments |
| Name | Current Value |
| EMAIL_PREV_ATTACH.PK_EMAIL_PREV_ATTACH |
| TableName | EMAIL_PREV_ATTACH |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EMAIL_PREV_ATTACH.PK_EMAIL_PREV_ATTACH Index Columns |
| ColumnName | Sort Order |
| TEMPLATE_ID | Ascending |
| SCHEMA | Ascending |
| ATTACH_ID | Ascending |
| SEQ_ID | Ascending |
| EMAIL_PREV_ATTACH.PK_EMAIL_PREV_ATTACH Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EMAIL_PREV_ATTACH.PK_EMAIL_PREV_ATTACH Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EMAIL_PREV_ATTACH.PK_EMAIL_PREV_ATTACH Bound Attachments |
| Name | Current Value |
| EMAIL_SENT.IDX_EMAIL_SENT |
| TableName | EMAIL_SENT |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | NO |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE INDEX XF_ADMIN.IDX_EMAIL_SENT ON XF_ADMIN.EMAIL_SENT(TEMPLATE_ID, RECPT_EMAIL_ADDR, PRPSL_ID) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE XF_ADMIN LOGGING STORAGE(INITIAL 256K NEXT 256K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) COMPRESS 2 ; |
| EMAIL_SENT.IDX_EMAIL_SENT Index Columns |
| ColumnName | Sort Order |
| TEMPLATE_ID | Ascending |
| RECPT_EMAIL_ADDR | Ascending |
| PRPSL_ID | Ascending |
| EMAIL_SENT.IDX_EMAIL_SENT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_ADMIN |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | B-Tree |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | DEFAULT |
| Index Compression | YES |
| Prefix Length | 2 |
| EMAIL_SENT.IDX_EMAIL_SENT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EMAIL_SENT.IDX_EMAIL_SENT Bound Attachments |
| Name | Current Value |
| EMAIL_TEMPLATE.PK_EMAIL_TEMPLATE |
| TableName | EMAIL_TEMPLATE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EMAIL_TEMPLATE.PK_EMAIL_TEMPLATE Index Columns |
| ColumnName | Sort Order |
| TEMPLATE_ID | Ascending |
| EMAIL_TEMPLATE.PK_EMAIL_TEMPLATE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_ADMIN |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | B-Tree |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | DEFAULT |
| Index Compression | NO |
| EMAIL_TEMPLATE.PK_EMAIL_TEMPLATE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EMAIL_TEMPLATE.PK_EMAIL_TEMPLATE Bound Attachments |
| Name | Current Value |
| EMAIL_TMPL_CC.PK_EMAIL_TMPL_CC |
| TableName | EMAIL_TMPL_CC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EMAIL_TMPL_CC.PK_EMAIL_TMPL_CC Index Columns |
| ColumnName | Sort Order |
| TEMPLATE_ID | Ascending |
| EMAIL_ADDR | Ascending |
| EMAIL_TMPL_CC.PK_EMAIL_TMPL_CC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_ADMIN |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | B-Tree |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | DEFAULT |
| Index Compression | NO |
| EMAIL_TMPL_CC.PK_EMAIL_TMPL_CC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EMAIL_TMPL_CC.PK_EMAIL_TMPL_CC Bound Attachments |
| Name | Current Value |
| EMAIL_TMPL_PRPSL_TYPE_ST_ASSC.PK_EMAIL_TMPL_PRPSL_TY_ST_ASSC |
| TableName | EMAIL_TMPL_PRPSL_TYPE_ST_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EMAIL_TMPL_PRPSL_TYPE_ST_ASSC.PK_EMAIL_TMPL_PRPSL_TY_ST_ASSC Index Columns |
| ColumnName | Sort Order |
| TEMPLATE_ID | Ascending |
| PRPSL_TYPE_ID | Ascending |
| STAT_ID | Ascending |
| EMAIL_TMPL_PRPSL_TYPE_ST_ASSC.PK_EMAIL_TMPL_PRPSL_TY_ST_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | B-Tree |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | DEFAULT |
| Index Compression | NO |
| EMAIL_TMPL_PRPSL_TYPE_ST_ASSC.PK_EMAIL_TMPL_PRPSL_TY_ST_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EMAIL_TMPL_PRPSL_TYPE_ST_ASSC.PK_EMAIL_TMPL_PRPSL_TY_ST_ASSC Bound Attachments |
| Name | Current Value |
| EMAIL_TMPL_RCPT.PK_EMAIL_TEMPLATE_RCPT |
| TableName | EMAIL_TMPL_RCPT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EMAIL_TMPL_RCPT.PK_EMAIL_TEMPLATE_RCPT Index Columns |
| ColumnName | Sort Order |
| TEMPLATE_ID | Ascending |
| EMAIL_ADDR | Ascending |
| EMAIL_TMPL_RCPT.PK_EMAIL_TEMPLATE_RCPT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_ADMIN |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | B-Tree |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | DEFAULT |
| Index Compression | NO |
| EMAIL_TMPL_RCPT.PK_EMAIL_TEMPLATE_RCPT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EMAIL_TMPL_RCPT.PK_EMAIL_TEMPLATE_RCPT Bound Attachments |
| Name | Current Value |
| EMAIL_TMPL_TAG.PK_TAG_SRC |
| TableName | EMAIL_TMPL_TAG |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EMAIL_TMPL_TAG.PK_TAG_SRC Index Columns |
| ColumnName | Sort Order |
| TEMPLATE_ID | Ascending |
| TAG_ID | Ascending |
| EMAIL_TMPL_TAG.PK_TAG_SRC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EMAIL_TMPL_TAG.PK_TAG_SRC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EMAIL_TMPL_TAG.PK_TAG_SRC Bound Attachments |
| Name | Current Value |
| EMAIL_TMPL_TAG.PK_TAG_SRC |
| TableName | EMAIL_TMPL_TAG |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EMAIL_TMPL_TAG.PK_TAG_SRC Index Columns |
| ColumnName | Sort Order |
| TEMPLATE_ID | Ascending |
| TAG_ID | Ascending |
| EMAIL_TMPL_TAG.PK_TAG_SRC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_ADMIN |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | B-Tree |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | DEFAULT |
| Index Compression | NO |
| EMAIL_TMPL_TAG.PK_TAG_SRC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EMAIL_TMPL_TAG.PK_TAG_SRC Bound Attachments |
| Name | Current Value |
| EMAIL_TMPL_TAG_GLOB.PK_EMAIL_TMPL_TAG_GLOB |
| TableName | EMAIL_TMPL_TAG_GLOB |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EMAIL_TMPL_TAG_GLOB.PK_EMAIL_TMPL_TAG_GLOB Index Columns |
| ColumnName | Sort Order |
| TAG_ID | Ascending |
| EMAIL_TMPL_TAG_GLOB.PK_EMAIL_TMPL_TAG_GLOB Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EMAIL_TMPL_TAG_GLOB.PK_EMAIL_TMPL_TAG_GLOB Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EMAIL_TMPL_TAG_GLOB.PK_EMAIL_TMPL_TAG_GLOB Bound Attachments |
| Name | Current Value |
| EMAIL_TMPL_TYPE.PK_EMAIL_TMPL_TYPE |
| TableName | EMAIL_TMPL_TYPE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EMAIL_TMPL_TYPE.PK_EMAIL_TMPL_TYPE Index Columns |
| ColumnName | Sort Order |
| EMAIL_TMPL_TYPE_ID | Ascending |
| EMAIL_TMPL_TYPE.PK_EMAIL_TMPL_TYPE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_ADMIN |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | B-Tree |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | DEFAULT |
| Index Compression | NO |
| EMAIL_TMPL_TYPE.PK_EMAIL_TMPL_TYPE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EMAIL_TMPL_TYPE.PK_EMAIL_TMPL_TYPE Bound Attachments |
| Name | Current Value |
| EMPLOYEE.PK_EMPLOYEE |
| TableName | EMPLOYEE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EMPLOYEE.PK_EMPLOYEE Index Columns |
| ColumnName | Sort Order |
| BN | Ascending |
| EMPLOYEE.PK_EMPLOYEE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| EMPLOYEE.PK_EMPLOYEE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EMPLOYEE.PK_EMPLOYEE Bound Attachments |
| Name | Current Value |
| ESH_ADMIN.PK_ESH_ADMIN |
| TableName | ESH_ADMIN |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| ESH_ADMIN.PK_ESH_ADMIN Index Columns |
| ColumnName | Sort Order |
| FACIL_ID | Ascending |
| PERSON_ID | Ascending |
| ESH_ADMIN.PK_ESH_ADMIN Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_OPER_TS |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | 1 |
| FREELIST GROUPS | 1 |
| Buffer Pool | |
| Index Compression | NO |
| ESH_ADMIN.PK_ESH_ADMIN Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| ESH_ADMIN.PK_ESH_ADMIN Bound Attachments |
| Name | Current Value |
| EXPT_FACIL.PK_EXPT_FACIL |
| TableName | EXPT_FACIL |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| EXPT_FACIL.PK_EXPT_FACIL Index Columns |
| ColumnName | Sort Order |
| FACIL_ID | Ascending |
| EXPT_FACIL.PK_EXPT_FACIL Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_OPER_INDEX_TS |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | 1 |
| FREELIST GROUPS | 1 |
| Buffer Pool | |
| Index Compression | NO |
| EXPT_FACIL.PK_EXPT_FACIL Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| EXPT_FACIL.PK_EXPT_FACIL Bound Attachments |
| Name | Current Value |
| FACIL_NOTC.PK_FACIL_NOTC |
| TableName | FACIL_NOTC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| FACIL_NOTC.PK_FACIL_NOTC Index Columns |
| ColumnName | Sort Order |
| FACIL_ID | Ascending |
| NOTC_ID | Ascending |
| FACIL_NOTC.PK_FACIL_NOTC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_OPER_INDEX_TS |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | 1 |
| FREELIST GROUPS | 1 |
| Buffer Pool | |
| Index Compression | NO |
| FACIL_NOTC.PK_FACIL_NOTC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| FACIL_NOTC.PK_FACIL_NOTC Bound Attachments |
| Name | Current Value |
| FACIL_RUN_CYCLE.PK_FACIL_RUN_CYCLE |
| TableName | FACIL_RUN_CYCLE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| FACIL_RUN_CYCLE.PK_FACIL_RUN_CYCLE Index Columns |
| ColumnName | Sort Order |
| FACIL_ID | Ascending |
| RUN_CYCLE_ID | Ascending |
| FACIL_RUN_CYCLE_ID | Ascending |
| FACIL_RUN_CYCLE.PK_FACIL_RUN_CYCLE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_OPER_TS |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | 1 |
| FREELIST GROUPS | 1 |
| Buffer Pool | |
| Index Compression | NO |
| FACIL_RUN_CYCLE.PK_FACIL_RUN_CYCLE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| FACIL_RUN_CYCLE.PK_FACIL_RUN_CYCLE Bound Attachments |
| Name | Current Value |
| FUND_SRC.PK_FUND_SRC |
| TableName | FUND_SRC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| FUND_SRC.PK_FUND_SRC Index Columns |
| ColumnName | Sort Order |
| FUND_ID | Ascending |
| FUND_SRC.PK_FUND_SRC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_OPER_INDEX_TS |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | 1 |
| FREELIST GROUPS | 1 |
| Buffer Pool | |
| Index Compression | NO |
| FUND_SRC.PK_FUND_SRC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| FUND_SRC.PK_FUND_SRC Bound Attachments |
| Name | Current Value |
| GLOVE_MATL.PK_GLOVE_MATL |
| TableName | GLOVE_MATL |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| GLOVE_MATL.PK_GLOVE_MATL Index Columns |
| ColumnName | Sort Order |
| GLOVE_MATL_ID | Ascending |
| GLOVE_MATL.PK_GLOVE_MATL Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| GLOVE_MATL.PK_GLOVE_MATL Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| GLOVE_MATL.PK_GLOVE_MATL Bound Attachments |
| Name | Current Value |
| INST.PK_INST |
| TableName | INST |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| INST.PK_INST Index Columns |
| ColumnName | Sort Order |
| INST_ID | Ascending |
| INST.PK_INST Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_OPER_INDEX_TS |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | 1 |
| FREELIST GROUPS | 1 |
| Buffer Pool | |
| Index Compression | NO |
| INST.PK_INST Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| INST.PK_INST Bound Attachments |
| Name | Current Value |
| INSTR.PK_INSTR |
| TableName | INSTR |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| INSTR.PK_INSTR Index Columns |
| ColumnName | Sort Order |
| INSTR_ID | Ascending |
| INSTR.PK_INSTR Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_OPER_INDEX_TS |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | 1 |
| FREELIST GROUPS | 1 |
| Buffer Pool | |
| Index Compression | NO |
| INSTR.PK_INSTR Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| INSTR.PK_INSTR Bound Attachments |
| Name | Current Value |
| INSTR_CONFIG.PK_INSTR_CONFIG |
| TableName | INSTR_CONFIG |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| INSTR_CONFIG.PK_INSTR_CONFIG Index Columns |
| ColumnName | Sort Order |
| INSTR_CONFIG_ID | Ascending |
| INSTR_CONFIG.PK_INSTR_CONFIG Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_OPER_INDEX_TS |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | 1 |
| FREELIST GROUPS | 1 |
| Buffer Pool | |
| Index Compression | NO |
| INSTR_CONFIG.PK_INSTR_CONFIG Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| INSTR_CONFIG.PK_INSTR_CONFIG Bound Attachments |
| Name | Current Value |
| INSTR_CONFIG_ASSC.PK_INSTR_CONFIG_ASSC |
| TableName | INSTR_CONFIG_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| INSTR_CONFIG_ASSC.PK_INSTR_CONFIG_ASSC Index Columns |
| ColumnName | Sort Order |
| INSTR_ID | Ascending |
| INSTR_CONFIG_ID | Ascending |
| INSTR_CONFIG_ASSC.PK_INSTR_CONFIG_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_OPER_INDEX_TS |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | 1 |
| FREELIST GROUPS | 1 |
| Buffer Pool | |
| Index Compression | NO |
| INSTR_CONFIG_ASSC.PK_INSTR_CONFIG_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| INSTR_CONFIG_ASSC.PK_INSTR_CONFIG_ASSC Bound Attachments |
| Name | Current Value |
| INSTR_CONT.PK_INSTR_CONT |
| TableName | INSTR_CONT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| INSTR_CONT.PK_INSTR_CONT Index Columns |
| ColumnName | Sort Order |
| INSTR_ID | Ascending |
| INSTR_CONT.PK_INSTR_CONT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_OPER_INDEX_TS |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | 1 |
| FREELIST GROUPS | 1 |
| Buffer Pool | |
| Index Compression | NO |
| INSTR_CONT.PK_INSTR_CONT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| INSTR_CONT.PK_INSTR_CONT Bound Attachments |
| Name | Current Value |
| INSTR_DEV_TEAM.PK_INSTR_DEV_TEAM |
| TableName | INSTR_DEV_TEAM |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| INSTR_DEV_TEAM.PK_INSTR_DEV_TEAM Index Columns |
| ColumnName | Sort Order |
| PERSON_ID | Ascending |
| INSTR_ID | Ascending |
| INSTR_DEV_TEAM.PK_INSTR_DEV_TEAM Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| INSTR_DEV_TEAM.PK_INSTR_DEV_TEAM Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| INSTR_DEV_TEAM.PK_INSTR_DEV_TEAM Bound Attachments |
| Name | Current Value |
| INSTR_GRP.PK_INSTR_1 |
| TableName | INSTR_GRP |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| INSTR_GRP.PK_INSTR_1 Index Columns |
| ColumnName | Sort Order |
| GRP_ID | Ascending |
| INSTR_GRP.PK_INSTR_1 Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_OPER_INDEX_TS |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | 1 |
| FREELIST GROUPS | 1 |
| Buffer Pool | |
| Index Compression | NO |
| INSTR_GRP.PK_INSTR_1 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| INSTR_GRP.PK_INSTR_1 Bound Attachments |
| Name | Current Value |
| INSTR_GRP_CHAIR.PK_INSTR_GRP_CHAIR |
| TableName | INSTR_GRP_CHAIR |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| INSTR_GRP_CHAIR.PK_INSTR_GRP_CHAIR Index Columns |
| ColumnName | Sort Order |
| GRP_ID | Ascending |
| PERSON_ID | Ascending |
| INSTR_GRP_CHAIR.PK_INSTR_GRP_CHAIR Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_OPER_TS |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | 1 |
| FREELIST GROUPS | 1 |
| Buffer Pool | |
| Index Compression | NO |
| INSTR_GRP_CHAIR.PK_INSTR_GRP_CHAIR Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| INSTR_GRP_CHAIR.PK_INSTR_GRP_CHAIR Bound Attachments |
| Name | Current Value |
| INSTR_GRP_REV_SUBCOMM_ASSC.PK_INSTR_GRP_REV_SUBCOMM_ASSC |
| TableName | INSTR_GRP_REV_SUBCOMM_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| INSTR_GRP_REV_SUBCOMM_ASSC.PK_INSTR_GRP_REV_SUBCOMM_ASSC Index Columns |
| ColumnName | Sort Order |
| GRP_ID | Ascending |
| SUBCOMM_ID | Ascending |
| INSTR_GRP_REV_SUBCOMM_ASSC.PK_INSTR_GRP_REV_SUBCOMM_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| INSTR_GRP_REV_SUBCOMM_ASSC.PK_INSTR_GRP_REV_SUBCOMM_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| INSTR_GRP_REV_SUBCOMM_ASSC.PK_INSTR_GRP_REV_SUBCOMM_ASSC Bound Attachments |
| Name | Current Value |
| INSTR_INSTR_PRPSL_ASSC.PK_INSTR_INSTR_PRPSL_ASSC |
| TableName | INSTR_INSTR_PRPSL_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| INSTR_INSTR_PRPSL_ASSC.PK_INSTR_INSTR_PRPSL_ASSC Index Columns |
| ColumnName | Sort Order |
| QUESTION_ID | Ascending |
| INSTR_ID | Ascending |
| INSTR_INSTR_PRPSL_ASSC.PK_INSTR_INSTR_PRPSL_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| INSTR_INSTR_PRPSL_ASSC.PK_INSTR_INSTR_PRPSL_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| INSTR_INSTR_PRPSL_ASSC.PK_INSTR_INSTR_PRPSL_ASSC Bound Attachments |
| Name | Current Value |
| INSTR_PRPSL_QUES.PK_INSTR_PRPSL_QUES |
| TableName | INSTR_PRPSL_QUES |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| INSTR_PRPSL_QUES.PK_INSTR_PRPSL_QUES Index Columns |
| ColumnName | Sort Order |
| QUESTION_ID | Ascending |
| INSTR_PRPSL_QUES.PK_INSTR_PRPSL_QUES Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| INSTR_PRPSL_QUES.PK_INSTR_PRPSL_QUES Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| INSTR_PRPSL_QUES.PK_INSTR_PRPSL_QUES Bound Attachments |
| Name | Current Value |
| INSTR_PRPSL_QUES_SEL_INSTR.PK_INSTR_PRPSL_QUES_SEL_INSTR |
| TableName | INSTR_PRPSL_QUES_SEL_INSTR |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| INSTR_PRPSL_QUES_SEL_INSTR.PK_INSTR_PRPSL_QUES_SEL_INSTR Index Columns |
| ColumnName | Sort Order |
| QUESTION_ID | Ascending |
| INSTR_ID | Ascending |
| INSTR_PRPSL_QUES_SEL_INSTR.PK_INSTR_PRPSL_QUES_SEL_INSTR Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| INSTR_PRPSL_QUES_SEL_INSTR.PK_INSTR_PRPSL_QUES_SEL_INSTR Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| INSTR_PRPSL_QUES_SEL_INSTR.PK_INSTR_PRPSL_QUES_SEL_INSTR Bound Attachments |
| Name | Current Value |
| INSTR_PRPSL_QUES_SEL_VAL.PK_INSTR_PRPSL_QUES_SEL_VAL |
| TableName | INSTR_PRPSL_QUES_SEL_VAL |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| INSTR_PRPSL_QUES_SEL_VAL.PK_INSTR_PRPSL_QUES_SEL_VAL Index Columns |
| ColumnName | Sort Order |
| QUESTION_ID | Ascending |
| VAL_ID | Ascending |
| INSTR_PRPSL_QUES_SEL_VAL.PK_INSTR_PRPSL_QUES_SEL_VAL Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| INSTR_PRPSL_QUES_SEL_VAL.PK_INSTR_PRPSL_QUES_SEL_VAL Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| INSTR_PRPSL_QUES_SEL_VAL.PK_INSTR_PRPSL_QUES_SEL_VAL Bound Attachments |
| Name | Current Value |
| INSTR_REVIEW.PK_INSTR_REVIEW |
| TableName | INSTR_REVIEW |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| INSTR_REVIEW.PK_INSTR_REVIEW Index Columns |
| ColumnName | Sort Order |
| INSTR_ID | Ascending |
| ROLE_ID | Ascending |
| PERSON_ID | Ascending |
| INSTR_REVIEW.PK_INSTR_REVIEW Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_OPER_INDEX_TS |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | 1 |
| FREELIST GROUPS | 1 |
| Buffer Pool | |
| Index Compression | NO |
| INSTR_REVIEW.PK_INSTR_REVIEW Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| INSTR_REVIEW.PK_INSTR_REVIEW Bound Attachments |
| Name | Current Value |
| INSTR_SCI.PK_INSTR_SCI |
| TableName | INSTR_SCI |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| INSTR_SCI.PK_INSTR_SCI Index Columns |
| ColumnName | Sort Order |
| INSTR_ID | Ascending |
| BN | Ascending |
| INSTR_SCI.PK_INSTR_SCI Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| INSTR_SCI.PK_INSTR_SCI Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| INSTR_SCI.PK_INSTR_SCI Bound Attachments |
| Name | Current Value |
| INSTR_SUP.PK_INSTR_SUP |
| TableName | INSTR_SUP |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| INSTR_SUP.PK_INSTR_SUP Index Columns |
| ColumnName | Sort Order |
| INSTR_ID | Ascending |
| BN | Ascending |
| SUP_ID | Ascending |
| INSTR_SUP.PK_INSTR_SUP Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| INSTR_SUP.PK_INSTR_SUP Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| INSTR_SUP.PK_INSTR_SUP Bound Attachments |
| Name | Current Value |
| INSTR_SUP_ROLE.PK_INSTR_SUP_ROLE |
| TableName | INSTR_SUP_ROLE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| INSTR_SUP_ROLE.PK_INSTR_SUP_ROLE Index Columns |
| ColumnName | Sort Order |
| SUP_ID | Ascending |
| INSTR_SUP_ROLE.PK_INSTR_SUP_ROLE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| INSTR_SUP_ROLE.PK_INSTR_SUP_ROLE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| INSTR_SUP_ROLE.PK_INSTR_SUP_ROLE Bound Attachments |
| Name | Current Value |
| INSTR_TEAM.PK_INSTR_TEAM |
| TableName | INSTR_TEAM |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| INSTR_TEAM.PK_INSTR_TEAM Index Columns |
| ColumnName | Sort Order |
| INSTR_ID | Ascending |
| Bn | Ascending |
| INSTR_TEAM.PK_INSTR_TEAM Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| INSTR_TEAM.PK_INSTR_TEAM Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| INSTR_TEAM.PK_INSTR_TEAM Bound Attachments |
| Name | Current Value |
| INSTR_UNAVAIL.PK_INSTR_UNAVAIL |
| TableName | INSTR_UNAVAIL |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| INSTR_UNAVAIL.PK_INSTR_UNAVAIL Index Columns |
| ColumnName | Sort Order |
| INSTR_ID | Ascending |
| BEGIN_DTE | Ascending |
| END_DTE | Ascending |
| INSTR_UNAVAIL.PK_INSTR_UNAVAIL Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| INSTR_UNAVAIL.PK_INSTR_UNAVAIL Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| INSTR_UNAVAIL.PK_INSTR_UNAVAIL Bound Attachments |
| Name | Current Value |
| LAB.PK_LAB |
| TableName | LAB |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| LAB.PK_LAB Index Columns |
| ColumnName | Sort Order |
| LAB_ID | Ascending |
| LAB.PK_LAB Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_OPER_INDEX_TS |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | 1 |
| FREELIST GROUPS | 1 |
| Buffer Pool | |
| Index Compression | NO |
| LAB.PK_LAB Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| LAB.PK_LAB Bound Attachments |
| Name | Current Value |
| LAB_PPE.PK_LAB_PPE |
| TableName | LAB_PPE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| LAB_PPE.PK_LAB_PPE Index Columns |
| ColumnName | Sort Order |
| LAB_PPE_ID | Ascending |
| LAB_PPE.PK_LAB_PPE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| LAB_PPE.PK_LAB_PPE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| LAB_PPE.PK_LAB_PPE Bound Attachments |
| Name | Current Value |
| MATL_ST.PK_MATL_ST |
| TableName | MATL_ST |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| MATL_ST.PK_MATL_ST Index Columns |
| ColumnName | Sort Order |
| ST_ID | Ascending |
| MATL_ST.PK_MATL_ST Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| MATL_ST.PK_MATL_ST Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| MATL_ST.PK_MATL_ST Bound Attachments |
| Name | Current Value |
| MERGE_ACCT_HIST.PK_MERGE_ACCT_HIST |
| TableName | MERGE_ACCT_HIST |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| MERGE_ACCT_HIST.PK_MERGE_ACCT_HIST Index Columns |
| ColumnName | Sort Order |
| PERSON_ID | Ascending |
| CUR_DTE | Ascending |
| MERGE_ACCT_HIST.PK_MERGE_ACCT_HIST Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| MERGE_ACCT_HIST.PK_MERGE_ACCT_HIST Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| MERGE_ACCT_HIST.PK_MERGE_ACCT_HIST Bound Attachments |
| Name | Current Value |
| NONVAL_INST.PK_NONVAL_INST |
| TableName | NONVAL_INST |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| NONVAL_INST.PK_NONVAL_INST Index Columns |
| ColumnName | Sort Order |
| NONVAL_INST_ID | Ascending |
| NONVAL_INST.PK_NONVAL_INST Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| NONVAL_INST.PK_NONVAL_INST Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| NONVAL_INST.PK_NONVAL_INST Bound Attachments |
| Name | Current Value |
| OPER_CYCLE.PK_OPER_CYCLE |
| TableName | OPER_CYCLE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| OPER_CYCLE.PK_OPER_CYCLE Index Columns |
| ColumnName | Sort Order |
| OPER_CYCLE_ID | Ascending |
| OPER_CYCLE.PK_OPER_CYCLE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | B-Tree |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | DEFAULT |
| Index Compression | NO |
| OPER_CYCLE.PK_OPER_CYCLE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| OPER_CYCLE.PK_OPER_CYCLE Bound Attachments |
| Name | Current Value |
| PERSON.PK_PERSON |
| TableName | PERSON |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PERSON.PK_PERSON Index Columns |
| ColumnName | Sort Order |
| PERSON_ID | Ascending |
| PERSON.PK_PERSON Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_OPER_INDEX_TS |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | 1 |
| FREELIST GROUPS | 1 |
| Buffer Pool | |
| Index Compression | NO |
| PERSON.PK_PERSON Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PERSON.PK_PERSON Bound Attachments |
| Name | Current Value |
| PERSON.idx_username |
| TableName | PERSON |
| Physical Only | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | Index |
| DDL Code | CREATE UNIQUE INDEX XF_ADMIN.idx_username ON XF_ADMIN.PERSON(USRNM) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE XF_OPER_TS LOGGING STORAGE(INITIAL 256K NEXT 256K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 ) ; |
| PERSON.idx_username Index Columns |
| ColumnName | Sort Order |
| USRNM | Ascending |
| PERSON.idx_username Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_OPER_TS |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | 1 |
| FREELIST GROUPS | 1 |
| Buffer Pool | |
| Index Compression | NO |
| PERSON.idx_username Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PERSON.idx_username Bound Attachments |
| Name | Current Value |
| PRPSL_SUBMISS.PK_PRPSL_SUBMISS |
| TableName | PRPSL_SUBMISS |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PRPSL_SUBMISS.PK_PRPSL_SUBMISS Index Columns |
| ColumnName | Sort Order |
| PRPSL_ID | Ascending |
| SUBMISS_NBR | Ascending |
| PRPSL_SUBMISS.PK_PRPSL_SUBMISS Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| PRPSL_SUBMISS.PK_PRPSL_SUBMISS Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PRPSL_SUBMISS.PK_PRPSL_SUBMISS Bound Attachments |
| Name | Current Value |
| PRPSL_TYPE.PK_PRPSL_TYPE |
| TableName | PRPSL_TYPE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| PRPSL_TYPE.PK_PRPSL_TYPE Index Columns |
| ColumnName | Sort Order |
| PRPSL_TYPE_ID | Ascending |
| PRPSL_TYPE.PK_PRPSL_TYPE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| PRPSL_TYPE.PK_PRPSL_TYPE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| PRPSL_TYPE.PK_PRPSL_TYPE Bound Attachments |
| Name | Current Value |
| REV_SUBCOMM.PK_REV_SUBCOMM |
| TableName | REV_SUBCOMM |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| REV_SUBCOMM.PK_REV_SUBCOMM Index Columns |
| ColumnName | Sort Order |
| SUBCOMM_ID | Ascending |
| REV_SUBCOMM.PK_REV_SUBCOMM Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| REV_SUBCOMM.PK_REV_SUBCOMM Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| REV_SUBCOMM.PK_REV_SUBCOMM Bound Attachments |
| Name | Current Value |
| REV_SUBCOMM_PERS_ASSC.PK_REV_SUBCOMM_PERS_ASSC |
| TableName | REV_SUBCOMM_PERS_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| REV_SUBCOMM_PERS_ASSC.PK_REV_SUBCOMM_PERS_ASSC Index Columns |
| ColumnName | Sort Order |
| SUBCOMM_ID | Ascending |
| PERSON_ID | Ascending |
| REV_SUBCOMM_PERS_ASSC.PK_REV_SUBCOMM_PERS_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| REV_SUBCOMM_PERS_ASSC.PK_REV_SUBCOMM_PERS_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| REV_SUBCOMM_PERS_ASSC.PK_REV_SUBCOMM_PERS_ASSC Bound Attachments |
| Name | Current Value |
| REV_SUBCOMM_PRPSL_ASSC.PK_REV_SUBCOMM_PRPSL_ASSC |
| TableName | REV_SUBCOMM_PRPSL_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| REV_SUBCOMM_PRPSL_ASSC.PK_REV_SUBCOMM_PRPSL_ASSC Index Columns |
| ColumnName | Sort Order |
| SUBCOMM_ID | Ascending |
| PRPSL_ID | Ascending |
| SUBMISS_NBR | Ascending |
| INSTR_ID | Ascending |
| REV_SUBCOMM_PRPSL_ASSC.PK_REV_SUBCOMM_PRPSL_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| REV_SUBCOMM_PRPSL_ASSC.PK_REV_SUBCOMM_PRPSL_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| REV_SUBCOMM_PRPSL_ASSC.PK_REV_SUBCOMM_PRPSL_ASSC Bound Attachments |
| Name | Current Value |
| REV_SUBCOMM_SCRIBE.PK_REV_SUBCOMM_SCRIBE |
| TableName | REV_SUBCOMM_SCRIBE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| REV_SUBCOMM_SCRIBE.PK_REV_SUBCOMM_SCRIBE Index Columns |
| ColumnName | Sort Order |
| SUBCOMM_ID | Ascending |
| PERSON_ID | Ascending |
| REV_SUBCOMM_SCRIBE.PK_REV_SUBCOMM_SCRIBE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| REV_SUBCOMM_SCRIBE.PK_REV_SUBCOMM_SCRIBE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| REV_SUBCOMM_SCRIBE.PK_REV_SUBCOMM_SCRIBE Bound Attachments |
| Name | Current Value |
| RUN_CYCLE.PK_RUN_CYCLE |
| TableName | RUN_CYCLE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| RUN_CYCLE.PK_RUN_CYCLE Index Columns |
| ColumnName | Sort Order |
| FACIL_ID | Ascending |
| RUN_CYCLE_ID | Ascending |
| RUN_CYCLE.PK_RUN_CYCLE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_OPER_TS |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | B-Tree |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | 1 |
| FREELIST GROUPS | 1 |
| Buffer Pool | DEFAULT |
| Index Compression | NO |
| RUN_CYCLE.PK_RUN_CYCLE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| RUN_CYCLE.PK_RUN_CYCLE Bound Attachments |
| Name | Current Value |
| SCI_HIGH.PK_SCI_HIGH |
| TableName | SCI_HIGH |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SCI_HIGH.PK_SCI_HIGH Index Columns |
| ColumnName | Sort Order |
| SCI_HIGH_ID | Ascending |
| SCI_HIGH.PK_SCI_HIGH Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SCI_HIGH.PK_SCI_HIGH Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SCI_HIGH.PK_SCI_HIGH Bound Attachments |
| Name | Current Value |
| SCI_HIGH_AUTH.PK_SCI_HIGH_AUTH |
| TableName | SCI_HIGH_AUTH |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SCI_HIGH_AUTH.PK_SCI_HIGH_AUTH Index Columns |
| ColumnName | Sort Order |
| EMAIL_ADDR | Ascending |
| SCI_HIGH_AUTH.PK_SCI_HIGH_AUTH Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SCI_HIGH_AUTH.PK_SCI_HIGH_AUTH Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SCI_HIGH_AUTH.PK_SCI_HIGH_AUTH Bound Attachments |
| Name | Current Value |
| SCI_HIGH_CAT.PK_SCI_HIGH_CAT |
| TableName | SCI_HIGH_CAT |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SCI_HIGH_CAT.PK_SCI_HIGH_CAT Index Columns |
| ColumnName | Sort Order |
| SCI_HIGH_CAT_ID | Ascending |
| SCI_HIGH_CAT.PK_SCI_HIGH_CAT Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SCI_HIGH_CAT.PK_SCI_HIGH_CAT Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SCI_HIGH_CAT.PK_SCI_HIGH_CAT Bound Attachments |
| Name | Current Value |
| SCI_HIGH_FACIL_ASSC.PK_SCI_HIGH_FACIL_ASSC |
| TableName | SCI_HIGH_FACIL_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SCI_HIGH_FACIL_ASSC.PK_SCI_HIGH_FACIL_ASSC Index Columns |
| ColumnName | Sort Order |
| SCI_HIGH_ID | Ascending |
| FACIL_ID | Ascending |
| SCI_HIGH_FACIL_ASSC.PK_SCI_HIGH_FACIL_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SCI_HIGH_FACIL_ASSC.PK_SCI_HIGH_FACIL_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SCI_HIGH_FACIL_ASSC.PK_SCI_HIGH_FACIL_ASSC Bound Attachments |
| Name | Current Value |
| SCI_HIGH_INSTR_ASSC.PK_SCI_HIGH_INSTR_ASSC |
| TableName | SCI_HIGH_INSTR_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SCI_HIGH_INSTR_ASSC.PK_SCI_HIGH_INSTR_ASSC Index Columns |
| ColumnName | Sort Order |
| SCI_HIGH_ID | Ascending |
| INSTR_ID | Ascending |
| SCI_HIGH_INSTR_ASSC.PK_SCI_HIGH_INSTR_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SCI_HIGH_INSTR_ASSC.PK_SCI_HIGH_INSTR_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SCI_HIGH_INSTR_ASSC.PK_SCI_HIGH_INSTR_ASSC Bound Attachments |
| Name | Current Value |
| SCI_HIGH_PI.PK_SCI_HIGH_PI |
| TableName | SCI_HIGH_PI |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SCI_HIGH_PI.PK_SCI_HIGH_PI Index Columns |
| ColumnName | Sort Order |
| EMAIL_ADDR | Ascending |
| SCI_HIGH_PI.PK_SCI_HIGH_PI Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SCI_HIGH_PI.PK_SCI_HIGH_PI Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SCI_HIGH_PI.PK_SCI_HIGH_PI Bound Attachments |
| Name | Current Value |
| SCI_HIGH_PI_ASSC.PK2274 |
| TableName | SCI_HIGH_PI_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SCI_HIGH_PI_ASSC.PK2274 Index Columns |
| ColumnName | Sort Order |
| SCI_HIGH_ID | Ascending |
| EMAIL_ADDR | Ascending |
| SCI_HIGH_PI_ASSC.PK2274 Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SCI_HIGH_PI_ASSC.PK2274 Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SCI_HIGH_PI_ASSC.PK2274 Bound Attachments |
| Name | Current Value |
| SCI_JOUR.PK_SCI_JOUR |
| TableName | SCI_JOUR |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SCI_JOUR.PK_SCI_JOUR Index Columns |
| ColumnName | Sort Order |
| JOUR_ID | Ascending |
| SCI_JOUR.PK_SCI_JOUR Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SCI_JOUR.PK_SCI_JOUR Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SCI_JOUR.PK_SCI_JOUR Bound Attachments |
| Name | Current Value |
| SCI_JOUR_HIGH_ASSC.PK_SCI_JOUR_HIGH_ASSC |
| TableName | SCI_JOUR_HIGH_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SCI_JOUR_HIGH_ASSC.PK_SCI_JOUR_HIGH_ASSC Index Columns |
| ColumnName | Sort Order |
| JOUR_ID | Ascending |
| SCI_HIGH_ID | Ascending |
| SCI_JOUR_HIGH_ASSC.PK_SCI_JOUR_HIGH_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SCI_JOUR_HIGH_ASSC.PK_SCI_JOUR_HIGH_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SCI_JOUR_HIGH_ASSC.PK_SCI_JOUR_HIGH_ASSC Bound Attachments |
| Name | Current Value |
| SCI_TOPIC.PK_SCI_TOPIC |
| TableName | SCI_TOPIC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SCI_TOPIC.PK_SCI_TOPIC Index Columns |
| ColumnName | Sort Order |
| TOPIC_ID | Ascending |
| SCI_TOPIC.PK_SCI_TOPIC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SCI_TOPIC.PK_SCI_TOPIC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SCI_TOPIC.PK_SCI_TOPIC Bound Attachments |
| Name | Current Value |
| SMPL_COND.PK_SMPL_COND |
| TableName | SMPL_COND |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_COND.PK_SMPL_COND Index Columns |
| ColumnName | Sort Order |
| SMPL_ENV_ID | Ascending |
| SMPL_COND_ID | Ascending |
| SMPL_COND.PK_SMPL_COND Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_OPER_TS |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | 1 |
| FREELIST GROUPS | 1 |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_COND.PK_SMPL_COND Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_COND.PK_SMPL_COND Bound Attachments |
| Name | Current Value |
| SMPL_COND_INSTR_ASSC.PK_SMPL_COND_INSTR_ASSC |
| TableName | SMPL_COND_INSTR_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_COND_INSTR_ASSC.PK_SMPL_COND_INSTR_ASSC Index Columns |
| ColumnName | Sort Order |
| SMPL_ENV_ID | Ascending |
| SMPL_COND_ID | Ascending |
| INSTR_ID | Ascending |
| SMPL_COND_INSTR_ASSC.PK_SMPL_COND_INSTR_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_COND_INSTR_ASSC.PK_SMPL_COND_INSTR_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_COND_INSTR_ASSC.PK_SMPL_COND_INSTR_ASSC Bound Attachments |
| Name | Current Value |
| SMPL_DESC.PK_SMPL_DESC |
| TableName | SMPL_DESC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_DESC.PK_SMPL_DESC Index Columns |
| ColumnName | Sort Order |
| SMPL_DESC_ID | Ascending |
| SMPL_DESC.PK_SMPL_DESC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | B-Tree |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | DEFAULT |
| Index Compression | NO |
| SMPL_DESC.PK_SMPL_DESC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_DESC.PK_SMPL_DESC Bound Attachments |
| Name | Current Value |
| SMPL_ENV.PK_SMPL_ENV |
| TableName | SMPL_ENV |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_ENV.PK_SMPL_ENV Index Columns |
| ColumnName | Sort Order |
| FACIL_ID | Ascending |
| SMPL_ENV_ID | Ascending |
| SMPL_ENV.PK_SMPL_ENV Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_OPER_INDEX_TS |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | 1 |
| FREELIST GROUPS | 1 |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_ENV.PK_SMPL_ENV Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_ENV.PK_SMPL_ENV Bound Attachments |
| Name | Current Value |
| SMPL_ENV_ATTR.PK_SMPL_ENV_ATTR |
| TableName | SMPL_ENV_ATTR |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_ENV_ATTR.PK_SMPL_ENV_ATTR Index Columns |
| ColumnName | Sort Order |
| SMPL_ENV_ID | Ascending |
| SMPL_ENV_ATTR.PK_SMPL_ENV_ATTR Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_OPER_TS |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | B-Tree |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | 1 |
| FREELIST GROUPS | 1 |
| Buffer Pool | DEFAULT |
| Index Compression | NO |
| SMPL_ENV_ATTR.PK_SMPL_ENV_ATTR Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_ENV_ATTR.PK_SMPL_ENV_ATTR Bound Attachments |
| Name | Current Value |
| SMPL_ENV_EQUIP_HAZ.PK_SMPL_ENV_EQUIP_HAZ |
| TableName | SMPL_ENV_EQUIP_HAZ |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_ENV_EQUIP_HAZ.PK_SMPL_ENV_EQUIP_HAZ Index Columns |
| ColumnName | Sort Order |
| EQUIP_HAZ_ID | Ascending |
| SMPL_ENV_EQUIP_HAZ.PK_SMPL_ENV_EQUIP_HAZ Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_ENV_EQUIP_HAZ.PK_SMPL_ENV_EQUIP_HAZ Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_ENV_EQUIP_HAZ.PK_SMPL_ENV_EQUIP_HAZ Bound Attachments |
| Name | Current Value |
| SMPL_ENV_INSTR_ASSC.PK_SMPL_ENV_INSTR_ASSC |
| TableName | SMPL_ENV_INSTR_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_ENV_INSTR_ASSC.PK_SMPL_ENV_INSTR_ASSC Index Columns |
| ColumnName | Sort Order |
| SMPL_ENV_ID | Ascending |
| INSTR_ID | Ascending |
| FACIL_ID | Ascending |
| SMPL_ENV_INSTR_ASSC.PK_SMPL_ENV_INSTR_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_ENV_INSTR_ASSC.PK_SMPL_ENV_INSTR_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_ENV_INSTR_ASSC.PK_SMPL_ENV_INSTR_ASSC Bound Attachments |
| Name | Current Value |
| SMPL_SAFE.PK_SMPL_SAFE |
| TableName | SMPL_SAFE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| SMPL_SAFE.PK_SMPL_SAFE Index Columns |
| ColumnName | Sort Order |
| SMPL_SAFE_ID | Ascending |
| SMPL_SAFE.PK_SMPL_SAFE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_OPER_INDEX_TS |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | 1 |
| FREELIST GROUPS | 1 |
| Buffer Pool | |
| Index Compression | NO |
| SMPL_SAFE.PK_SMPL_SAFE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| SMPL_SAFE.PK_SMPL_SAFE Bound Attachments |
| Name | Current Value |
| STATE.PK_STATE |
| TableName | STATE |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| STATE.PK_STATE Index Columns |
| ColumnName | Sort Order |
| STATE_ID | Ascending |
| STATE.PK_STATE Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| STATE.PK_STATE Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| STATE.PK_STATE Bound Attachments |
| Name | Current Value |
| TRAIN_FACIL_ASSC.PK_TRAIN_FACIL_ASSC |
| TableName | TRAIN_FACIL_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| TRAIN_FACIL_ASSC.PK_TRAIN_FACIL_ASSC Index Columns |
| ColumnName | Sort Order |
| FACIL_ID | Ascending |
| MOD_ID | Ascending |
| TRAIN_FACIL_ASSC.PK_TRAIN_FACIL_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| TRAIN_FACIL_ASSC.PK_TRAIN_FACIL_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| TRAIN_FACIL_ASSC.PK_TRAIN_FACIL_ASSC Bound Attachments |
| Name | Current Value |
| TRAIN_INSTR_ASSC.PK_TRAIN_INSTR_ASSC |
| TableName | TRAIN_INSTR_ASSC |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| TRAIN_INSTR_ASSC.PK_TRAIN_INSTR_ASSC Index Columns |
| ColumnName | Sort Order |
| INSTR_ID | Ascending |
| MOD_ID | Ascending |
| TRAIN_INSTR_ASSC.PK_TRAIN_INSTR_ASSC Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| TRAIN_INSTR_ASSC.PK_TRAIN_INSTR_ASSC Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| TRAIN_INSTR_ASSC.PK_TRAIN_INSTR_ASSC Bound Attachments |
| Name | Current Value |
| TRAIN_MOD.PK_TRAIN_MOD |
| TableName | TRAIN_MOD |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| TRAIN_MOD.PK_TRAIN_MOD Index Columns |
| ColumnName | Sort Order |
| MOD_ID | Ascending |
| TRAIN_MOD.PK_TRAIN_MOD Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| TRAIN_MOD.PK_TRAIN_MOD Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| TRAIN_MOD.PK_TRAIN_MOD Bound Attachments |
| Name | Current Value |
| TRAIN_PERSON.PK_TRAIN_PERSON |
| TableName | TRAIN_PERSON |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| TRAIN_PERSON.PK_TRAIN_PERSON Index Columns |
| ColumnName | Sort Order |
| PERSON_ID | Ascending |
| MOD_ID | Ascending |
| CMPLT_DTE | Ascending |
| TRAIN_PERSON.PK_TRAIN_PERSON Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| TRAIN_PERSON.PK_TRAIN_PERSON Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| TRAIN_PERSON.PK_TRAIN_PERSON Bound Attachments |
| Name | Current Value |
| UNIT_LEN.PK_UNIT_LEN |
| TableName | UNIT_LEN |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| UNIT_LEN.PK_UNIT_LEN Index Columns |
| ColumnName | Sort Order |
| LEN_UNIT_ID | Ascending |
| UNIT_LEN.PK_UNIT_LEN Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_OPER_INDEX_TS |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | 1 |
| FREELIST GROUPS | 1 |
| Buffer Pool | |
| Index Compression | NO |
| UNIT_LEN.PK_UNIT_LEN Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| UNIT_LEN.PK_UNIT_LEN Bound Attachments |
| Name | Current Value |
| UNIT_MASS.PK_UNIT_MASS |
| TableName | UNIT_MASS |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| UNIT_MASS.PK_UNIT_MASS Index Columns |
| ColumnName | Sort Order |
| MASS_UNIT_ID | Ascending |
| UNIT_MASS.PK_UNIT_MASS Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | XF_OPER_INDEX_TS |
| PctFree | 10 |
| MinExtents | 1 |
| MaxExtents | 2147483645 |
| Initial | 256 |
| Next | 256 |
| PctIncrease | 0 |
| InitTrans | 2 |
| MaxTrans | 255 |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | 1 |
| FREELIST GROUPS | 1 |
| Buffer Pool | |
| Index Compression | NO |
| UNIT_MASS.PK_UNIT_MASS Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| UNIT_MASS.PK_UNIT_MASS Bound Attachments |
| Name | Current Value |
| UNIT_OF_PRESS.PK_UNIT_OF_PRESS |
| TableName | UNIT_OF_PRESS |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| UNIT_OF_PRESS.PK_UNIT_OF_PRESS Index Columns |
| ColumnName | Sort Order |
| PRESS_UNIT_ID | Ascending |
| UNIT_OF_PRESS.PK_UNIT_OF_PRESS Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| UNIT_OF_PRESS.PK_UNIT_OF_PRESS Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| UNIT_OF_PRESS.PK_UNIT_OF_PRESS Bound Attachments |
| Name | Current Value |
| UNIT_TEMP.PK_UNIT_TEMP |
| TableName | UNIT_TEMP |
| Physical Only | NO |
| Disabled | NO |
| NoValidate | NO |
| PK/UK Constraint Name | |
| Unique | YES |
| Clustered Option | NON-CLUSTERED |
| IndexType | PrimaryKey |
| DDL Code |
| UNIT_TEMP.PK_UNIT_TEMP Index Columns |
| ColumnName | Sort Order |
| TEMP_UNIT_ID | Ascending |
| UNIT_TEMP.PK_UNIT_TEMP Properties |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | |
| PctFree | |
| MinExtents | |
| MaxExtents | |
| Initial | |
| Next | |
| PctIncrease | |
| InitTrans | |
| MaxTrans | |
| NO SORT | NO |
| Type | |
| Byte Order | |
| Logging | |
| Parallel | NO |
| Parallel Degrees | |
| Parallel Instances | |
| FREELISTS | |
| FREELIST GROUPS | |
| Buffer Pool | |
| Index Compression | NO |
| UNIT_TEMP.PK_UNIT_TEMP Partitions |
| PARTITION PROPERTY | PARTITION PROPERTY VALUE |
| UNIT_TEMP.PK_UNIT_TEMP Bound Attachments |
| Name | Current Value |