ANT_MEAS.PK_ANT_MEAS |
TableName | ANT_MEAS |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
ANT_MEAS.PK_ANT_MEAS Index Columns |
ColumnName | Sort Order |
REBUILD_ID | Ascending |
COMPO_ID | Ascending |
ANT_MEAS.PK_ANT_MEAS Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
ANT_MEAS.PK_ANT_MEAS Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
ANT_MEAS.PK_ANT_MEAS Bound Attachments |
Name | Current Value |
ANT_MEAS.FK_ANT_MEAS_ISC |
TableName | ANT_MEAS |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IONSRC.FK_ANT_MEAS_ISC ON IONSRC.ANT_MEAS(COMPO_ID) TABLESPACE ionsrc_ts      LOGGING ; |
ANT_MEAS.FK_ANT_MEAS_ISC Index Columns |
ColumnName | Sort Order |
COMPO_ID | Ascending |
ANT_MEAS.FK_ANT_MEAS_ISC Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
ANT_MEAS.FK_ANT_MEAS_ISC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
ANT_MEAS.FK_ANT_MEAS_ISC Bound Attachments |
Name | Current Value |
ANT_MEAS.FK_ANT_TYPE_AM |
TableName | ANT_MEAS |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IONSRC.FK_ANT_TYPE_AM ON IONSRC.ANT_MEAS(ANT_TYPE_ID) TABLESPACE ionsrc_ts      LOGGING ; |
ANT_MEAS.FK_ANT_TYPE_AM Index Columns |
ColumnName | Sort Order |
ANT_TYPE_ID | Ascending |
ANT_MEAS.FK_ANT_TYPE_AM Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
ANT_MEAS.FK_ANT_TYPE_AM Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
ANT_MEAS.FK_ANT_TYPE_AM Bound Attachments |
Name | Current Value |
ANT_MEAS.FK_ANT_MEAS_RP |
TableName | ANT_MEAS |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IONSRC.FK_ANT_MEAS_RP ON IONSRC.ANT_MEAS(REBUILD_ID) TABLESPACE ionsrc_ts      LOGGING ; |
ANT_MEAS.FK_ANT_MEAS_RP Index Columns |
ColumnName | Sort Order |
REBUILD_ID | Ascending |
ANT_MEAS.FK_ANT_MEAS_RP Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
ANT_MEAS.FK_ANT_MEAS_RP Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
ANT_MEAS.FK_ANT_MEAS_RP Bound Attachments |
Name | Current Value |
ANT_TYPE.PK_ANT_TYPE |
TableName | ANT_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
ANT_TYPE.PK_ANT_TYPE Index Columns |
ColumnName | Sort Order |
ANT_TYPE_ID | Ascending |
ANT_TYPE.PK_ANT_TYPE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
ANT_TYPE.PK_ANT_TYPE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
ANT_TYPE.PK_ANT_TYPE Bound Attachments |
Name | Current Value |
INSTALL_LOC.PK_INSTALL_LOC |
TableName | INSTALL_LOC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INSTALL_LOC.PK_INSTALL_LOC Index Columns |
ColumnName | Sort Order |
INSTALL_ID | Ascending |
INSTALL_LOC.PK_INSTALL_LOC Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
INSTALL_LOC.PK_INSTALL_LOC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INSTALL_LOC.PK_INSTALL_LOC Bound Attachments |
Name | Current Value |
ION_SRC_COMPO.PK_ION_SRC_COMPO |
TableName | ION_SRC_COMPO |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
ION_SRC_COMPO.PK_ION_SRC_COMPO Index Columns |
ColumnName | Sort Order |
COMPO_ID | Ascending |
ION_SRC_COMPO.PK_ION_SRC_COMPO Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
ION_SRC_COMPO.PK_ION_SRC_COMPO Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
ION_SRC_COMPO.PK_ION_SRC_COMPO Bound Attachments |
Name | Current Value |
ION_SRC_REMOVAL.PK_ION_SRC_REMOVAL |
TableName | ION_SRC_REMOVAL |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
ION_SRC_REMOVAL.PK_ION_SRC_REMOVAL Index Columns |
ColumnName | Sort Order |
REMOVAL_ID | Ascending |
ION_SRC_REMOVAL.PK_ION_SRC_REMOVAL Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
ION_SRC_REMOVAL.PK_ION_SRC_REMOVAL Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
ION_SRC_REMOVAL.PK_ION_SRC_REMOVAL Bound Attachments |
Name | Current Value |
ION_SRC_TYPE.PK_ION_SRC_TYPE |
TableName | ION_SRC_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
ION_SRC_TYPE.PK_ION_SRC_TYPE Index Columns |
ColumnName | Sort Order |
ION_SRC_TYPE_ID | Ascending |
ION_SRC_TYPE.PK_ION_SRC_TYPE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
ION_SRC_TYPE.PK_ION_SRC_TYPE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
ION_SRC_TYPE.PK_ION_SRC_TYPE Bound Attachments |
Name | Current Value |
LEBT_CONF.PK_LEBT_CONF |
TableName | LEBT_CONF |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LEBT_CONF.PK_LEBT_CONF Index Columns |
ColumnName | Sort Order |
LEBT_CONF_ID | Ascending |
LEBT_CONF.PK_LEBT_CONF Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
LEBT_CONF.PK_LEBT_CONF Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LEBT_CONF.PK_LEBT_CONF Bound Attachments |
Name | Current Value |
MAG_CON_CONFIG.PK_MAG_CON_CONFIG |
TableName | MAG_CON_CONFIG |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MAG_CON_CONFIG.PK_MAG_CON_CONFIG Index Columns |
ColumnName | Sort Order |
MAG_CON_CONF_ID | Ascending |
MAG_CON_CONFIG.PK_MAG_CON_CONFIG Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
MAG_CON_CONFIG.PK_MAG_CON_CONFIG Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MAG_CON_CONFIG.PK_MAG_CON_CONFIG Bound Attachments |
Name | Current Value |
OPER_PHASE.PK_OPER_PHASE |
TableName | OPER_PHASE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
OPER_PHASE.PK_OPER_PHASE Index Columns |
ColumnName | Sort Order |
REBUILD_ID | Ascending |
OPER_PHASE.PK_OPER_PHASE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
OPER_PHASE.PK_OPER_PHASE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
OPER_PHASE.PK_OPER_PHASE Bound Attachments |
Name | Current Value |
OPER_PHASE.FK_OPER_PHASE_INSTALL_LOC |
TableName | OPER_PHASE |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IONSRC.FK_OPER_PHASE_INSTALL_LOC ON IONSRC.OPER_PHASE(INSTALL_ID) TABLESPACE ionsrc_ts      LOGGING ; |
OPER_PHASE.FK_OPER_PHASE_INSTALL_LOC Index Columns |
ColumnName | Sort Order |
INSTALL_ID | Ascending |
OPER_PHASE.FK_OPER_PHASE_INSTALL_LOC Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
OPER_PHASE.FK_OPER_PHASE_INSTALL_LOC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
OPER_PHASE.FK_OPER_PHASE_INSTALL_LOC Bound Attachments |
Name | Current Value |
OPER_PHASE.FK_OPER_PHASE_ISR |
TableName | OPER_PHASE |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IONSRC.FK_OPER_PHASE_ISR ON IONSRC.OPER_PHASE(REMOVAL_ID) TABLESPACE ionsrc_ts      LOGGING ; |
OPER_PHASE.FK_OPER_PHASE_ISR Index Columns |
ColumnName | Sort Order |
REMOVAL_ID | Ascending |
OPER_PHASE.FK_OPER_PHASE_ISR Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
OPER_PHASE.FK_OPER_PHASE_ISR Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
OPER_PHASE.FK_OPER_PHASE_ISR Bound Attachments |
Name | Current Value |
OPER_PHASE.FK_OPER_PHASE_RP |
TableName | OPER_PHASE |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IONSRC.FK_OPER_PHASE_RP ON IONSRC.OPER_PHASE(REBUILD_ID) TABLESPACE ionsrc_ts      LOGGING ; |
OPER_PHASE.FK_OPER_PHASE_RP Index Columns |
ColumnName | Sort Order |
REBUILD_ID | Ascending |
OPER_PHASE.FK_OPER_PHASE_RP Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
OPER_PHASE.FK_OPER_PHASE_RP Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
OPER_PHASE.FK_OPER_PHASE_RP Bound Attachments |
Name | Current Value |
OPER_PHASE_CESS.PK_OPER_PHASE_CESS |
TableName | OPER_PHASE_CESS |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
OPER_PHASE_CESS.PK_OPER_PHASE_CESS Index Columns |
ColumnName | Sort Order |
REBUILD_ID | Ascending |
CESS_DTE | Ascending |
OPER_PHASE_CESS.PK_OPER_PHASE_CESS Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
OPER_PHASE_CESS.PK_OPER_PHASE_CESS Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
OPER_PHASE_CESS.PK_OPER_PHASE_CESS Bound Attachments |
Name | Current Value |
OPER_PHASE_CESS.FK_OPER_PHASE_CESS_OP |
TableName | OPER_PHASE_CESS |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IONSRC.FK_OPER_PHASE_CESS_OP ON IONSRC.OPER_PHASE_CESS(REBUILD_ID) TABLESPACE ionsrc_ts      LOGGING ; |
OPER_PHASE_CESS.FK_OPER_PHASE_CESS_OP Index Columns |
ColumnName | Sort Order |
REBUILD_ID | Ascending |
OPER_PHASE_CESS.FK_OPER_PHASE_CESS_OP Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
OPER_PHASE_CESS.FK_OPER_PHASE_CESS_OP Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
OPER_PHASE_CESS.FK_OPER_PHASE_CESS_OP Bound Attachments |
Name | Current Value |
POST_OPER_INSP_PHASE.PK_POST_OPER_INSPO_PHASE |
TableName | POST_OPER_INSP_PHASE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
POST_OPER_INSP_PHASE.PK_POST_OPER_INSPO_PHASE Index Columns |
ColumnName | Sort Order |
REBUILD_ID | Ascending |
COMPO_ID | Ascending |
POST_OPER_INSP_PHASE.PK_POST_OPER_INSPO_PHASE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
POST_OPER_INSP_PHASE.PK_POST_OPER_INSPO_PHASE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
POST_OPER_INSP_PHASE.PK_POST_OPER_INSPO_PHASE Bound Attachments |
Name | Current Value |
POST_OPER_INSP_PHASE.FK_POST_OPER_INSP_PHASE_ISC |
TableName | POST_OPER_INSP_PHASE |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IONSRC.FK_POST_OPER_INSP_PHASE_ISC ON IONSRC.POST_OPER_INSP_PHASE(COMPO_ID) TABLESPACE ionsrc_ts      LOGGING ; |
POST_OPER_INSP_PHASE.FK_POST_OPER_INSP_PHASE_ISC Index Columns |
ColumnName | Sort Order |
COMPO_ID | Ascending |
POST_OPER_INSP_PHASE.FK_POST_OPER_INSP_PHASE_ISC Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
POST_OPER_INSP_PHASE.FK_POST_OPER_INSP_PHASE_ISC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
POST_OPER_INSP_PHASE.FK_POST_OPER_INSP_PHASE_ISC Bound Attachments |
Name | Current Value |
POST_OPER_INSP_PHASE.FK_POST_OPER_INSP_PHASE_RP |
TableName | POST_OPER_INSP_PHASE |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IONSRC.FK_POST_OPER_INSP_PHASE_RP ON IONSRC.POST_OPER_INSP_PHASE(REBUILD_ID) TABLESPACE ionsrc_ts      LOGGING ; |
POST_OPER_INSP_PHASE.FK_POST_OPER_INSP_PHASE_RP Index Columns |
ColumnName | Sort Order |
REBUILD_ID | Ascending |
POST_OPER_INSP_PHASE.FK_POST_OPER_INSP_PHASE_RP Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
POST_OPER_INSP_PHASE.FK_POST_OPER_INSP_PHASE_RP Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
POST_OPER_INSP_PHASE.FK_POST_OPER_INSP_PHASE_RP Bound Attachments |
Name | Current Value |
POST_OPER_INSP_PHASE_NOTE.PK_POST_OPER_INSP_PHASE |
TableName | POST_OPER_INSP_PHASE_NOTE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
POST_OPER_INSP_PHASE_NOTE.PK_POST_OPER_INSP_PHASE Index Columns |
ColumnName | Sort Order |
COMPO_ID | Ascending |
REBUILD_ID | Ascending |
POST_OPER_INSP_PHASE_NOTE.PK_POST_OPER_INSP_PHASE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
POST_OPER_INSP_PHASE_NOTE.PK_POST_OPER_INSP_PHASE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
POST_OPER_INSP_PHASE_NOTE.PK_POST_OPER_INSP_PHASE Bound Attachments |
Name | Current Value |
POST_OPER_INSP_PHASE_NOTE.FK_POST_OPER_INSP_PHASE_POTIP |
TableName | POST_OPER_INSP_PHASE_NOTE |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IONSRC.FK_POST_OPER_INSP_PHASE_POTIP ON IONSRC.POST_OPER_INSP_PHASE_NOTE(COMPO_ID, REBUILD_ID) TABLESPACE ionsrc_ts      LOGGING ; |
POST_OPER_INSP_PHASE_NOTE.FK_POST_OPER_INSP_PHASE_POTIP Index Columns |
ColumnName | Sort Order |
COMPO_ID | Ascending |
REBUILD_ID | Ascending |
POST_OPER_INSP_PHASE_NOTE.FK_POST_OPER_INSP_PHASE_POTIP Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
POST_OPER_INSP_PHASE_NOTE.FK_POST_OPER_INSP_PHASE_POTIP Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
POST_OPER_INSP_PHASE_NOTE.FK_POST_OPER_INSP_PHASE_POTIP Bound Attachments |
Name | Current Value |
PRE_REBUILD_NOTE.PK_PRE_REBUILD_NOTE |
TableName | PRE_REBUILD_NOTE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRE_REBUILD_NOTE.PK_PRE_REBUILD_NOTE Index Columns |
ColumnName | Sort Order |
COMPO_ID | Ascending |
ITEM_NBR | Ascending |
PRE_REBUILD_NOTE.PK_PRE_REBUILD_NOTE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
PRE_REBUILD_NOTE.PK_PRE_REBUILD_NOTE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRE_REBUILD_NOTE.PK_PRE_REBUILD_NOTE Bound Attachments |
Name | Current Value |
PRE_REBUILD_NOTE.FK_PRE_REBUILD_NOTE_ISC |
TableName | PRE_REBUILD_NOTE |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IONSRC.FK_PRE_REBUILD_NOTE_ISC ON IONSRC.PRE_REBUILD_NOTE(COMPO_ID) TABLESPACE ionsrc_ts      LOGGING ; |
PRE_REBUILD_NOTE.FK_PRE_REBUILD_NOTE_ISC Index Columns |
ColumnName | Sort Order |
COMPO_ID | Ascending |
PRE_REBUILD_NOTE.FK_PRE_REBUILD_NOTE_ISC Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
PRE_REBUILD_NOTE.FK_PRE_REBUILD_NOTE_ISC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRE_REBUILD_NOTE.FK_PRE_REBUILD_NOTE_ISC Bound Attachments |
Name | Current Value |
PRE_REBUILD_NOTE_ASGN.PK_PRE_REBUILD_NOTE_ASGN |
TableName | PRE_REBUILD_NOTE_ASGN |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRE_REBUILD_NOTE_ASGN.PK_PRE_REBUILD_NOTE_ASGN Index Columns |
ColumnName | Sort Order |
REBUILD_ID | Ascending |
COMPO_ID | Ascending |
ITEM_NBR | Ascending |
PRE_REBUILD_NOTE_ASGN.PK_PRE_REBUILD_NOTE_ASGN Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
PRE_REBUILD_NOTE_ASGN.PK_PRE_REBUILD_NOTE_ASGN Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRE_REBUILD_NOTE_ASGN.PK_PRE_REBUILD_NOTE_ASGN Bound Attachments |
Name | Current Value |
PRE_REBUILD_NOTE_ASGN.FK_PRE_REBUILD_NOTE_ASGN_RCA |
TableName | PRE_REBUILD_NOTE_ASGN |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IONSRC.FK_PRE_REBUILD_NOTE_ASGN_RCA ON IONSRC.PRE_REBUILD_NOTE_ASGN(REBUILD_ID, COMPO_ID) TABLESPACE ionsrc_ts      LOGGING ; |
PRE_REBUILD_NOTE_ASGN.FK_PRE_REBUILD_NOTE_ASGN_RCA Index Columns |
ColumnName | Sort Order |
REBUILD_ID | Ascending |
COMPO_ID | Ascending |
PRE_REBUILD_NOTE_ASGN.FK_PRE_REBUILD_NOTE_ASGN_RCA Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
PRE_REBUILD_NOTE_ASGN.FK_PRE_REBUILD_NOTE_ASGN_RCA Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRE_REBUILD_NOTE_ASGN.FK_PRE_REBUILD_NOTE_ASGN_RCA Bound Attachments |
Name | Current Value |
PRE_REBUILD_NOTE_ASGN.FK_PRE_REBUILD_NOTE_ASGN_PRN |
TableName | PRE_REBUILD_NOTE_ASGN |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IONSRC.FK_PRE_REBUILD_NOTE_ASGN_PRN ON IONSRC.PRE_REBUILD_NOTE_ASGN(COMPO_ID, ITEM_NBR) TABLESPACE ionsrc_ts      LOGGING ; |
PRE_REBUILD_NOTE_ASGN.FK_PRE_REBUILD_NOTE_ASGN_PRN Index Columns |
ColumnName | Sort Order |
COMPO_ID | Ascending |
ITEM_NBR | Ascending |
PRE_REBUILD_NOTE_ASGN.FK_PRE_REBUILD_NOTE_ASGN_PRN Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
PRE_REBUILD_NOTE_ASGN.FK_PRE_REBUILD_NOTE_ASGN_PRN Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRE_REBUILD_NOTE_ASGN.FK_PRE_REBUILD_NOTE_ASGN_PRN Bound Attachments |
Name | Current Value |
PRE_TEAR_NOTE_ASGN.PK_PRE_TEARDOWN_NOTE_ASGN |
TableName | PRE_TEAR_NOTE_ASGN |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRE_TEAR_NOTE_ASGN.PK_PRE_TEARDOWN_NOTE_ASGN Index Columns |
ColumnName | Sort Order |
REBUILD_ID | Ascending |
COMPO_ID | Ascending |
ITEM_NBR | Ascending |
PRE_TEAR_NOTE_ASGN.PK_PRE_TEARDOWN_NOTE_ASGN Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
PRE_TEAR_NOTE_ASGN.PK_PRE_TEARDOWN_NOTE_ASGN Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRE_TEAR_NOTE_ASGN.PK_PRE_TEARDOWN_NOTE_ASGN Bound Attachments |
Name | Current Value |
PRE_TEAR_NOTE_ASGN.FK_PRE_TEAR_NOTE_ASGN_POTIP |
TableName | PRE_TEAR_NOTE_ASGN |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IONSRC.FK_PRE_TEAR_NOTE_ASGN_POTIP ON IONSRC.PRE_TEAR_NOTE_ASGN(REBUILD_ID, COMPO_ID) TABLESPACE ionsrc_ts      LOGGING ; |
PRE_TEAR_NOTE_ASGN.FK_PRE_TEAR_NOTE_ASGN_POTIP Index Columns |
ColumnName | Sort Order |
REBUILD_ID | Ascending |
COMPO_ID | Ascending |
PRE_TEAR_NOTE_ASGN.FK_PRE_TEAR_NOTE_ASGN_POTIP Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
PRE_TEAR_NOTE_ASGN.FK_PRE_TEAR_NOTE_ASGN_POTIP Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRE_TEAR_NOTE_ASGN.FK_PRE_TEAR_NOTE_ASGN_POTIP Bound Attachments |
Name | Current Value |
PRE_TEAR_NOTE_ASGN.FK_PRE_TEAR_NOTE_ASGN_PTN |
TableName | PRE_TEAR_NOTE_ASGN |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IONSRC.FK_PRE_TEAR_NOTE_ASGN_PTN ON IONSRC.PRE_TEAR_NOTE_ASGN(COMPO_ID, ITEM_NBR) TABLESPACE ionsrc_ts      LOGGING ; |
PRE_TEAR_NOTE_ASGN.FK_PRE_TEAR_NOTE_ASGN_PTN Index Columns |
ColumnName | Sort Order |
COMPO_ID | Ascending |
ITEM_NBR | Ascending |
PRE_TEAR_NOTE_ASGN.FK_PRE_TEAR_NOTE_ASGN_PTN Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
PRE_TEAR_NOTE_ASGN.FK_PRE_TEAR_NOTE_ASGN_PTN Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRE_TEAR_NOTE_ASGN.FK_PRE_TEAR_NOTE_ASGN_PTN Bound Attachments |
Name | Current Value |
PRE_TEARDOWN_NOTE.PK_PRE_TEARDOWN_NOTE |
TableName | PRE_TEARDOWN_NOTE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
PRE_TEARDOWN_NOTE.PK_PRE_TEARDOWN_NOTE Index Columns |
ColumnName | Sort Order |
COMPO_ID | Ascending |
ITEM_NBR | Ascending |
PRE_TEARDOWN_NOTE.PK_PRE_TEARDOWN_NOTE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
PRE_TEARDOWN_NOTE.PK_PRE_TEARDOWN_NOTE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRE_TEARDOWN_NOTE.PK_PRE_TEARDOWN_NOTE Bound Attachments |
Name | Current Value |
PRE_TEARDOWN_NOTE.FK_PRE_TEARDOWN_NOTE_ISC |
TableName | PRE_TEARDOWN_NOTE |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IONSRC.FK_PRE_TEARDOWN_NOTE_ISC ON IONSRC.PRE_TEARDOWN_NOTE(COMPO_ID) TABLESPACE ionsrc_ts      LOGGING ; |
PRE_TEARDOWN_NOTE.FK_PRE_TEARDOWN_NOTE_ISC Index Columns |
ColumnName | Sort Order |
COMPO_ID | Ascending |
PRE_TEARDOWN_NOTE.FK_PRE_TEARDOWN_NOTE_ISC Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
PRE_TEARDOWN_NOTE.FK_PRE_TEARDOWN_NOTE_ISC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
PRE_TEARDOWN_NOTE.FK_PRE_TEARDOWN_NOTE_ISC Bound Attachments |
Name | Current Value |
REBUILD_COMPO_ASGN.PK_REBUILD_COMPO_ASGN |
TableName | REBUILD_COMPO_ASGN |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
REBUILD_COMPO_ASGN.PK_REBUILD_COMPO_ASGN Index Columns |
ColumnName | Sort Order |
REBUILD_ID | Ascending |
COMPO_ID | Ascending |
REBUILD_COMPO_ASGN.PK_REBUILD_COMPO_ASGN Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
REBUILD_COMPO_ASGN.PK_REBUILD_COMPO_ASGN Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
REBUILD_COMPO_ASGN.PK_REBUILD_COMPO_ASGN Bound Attachments |
Name | Current Value |
REBUILD_COMPO_ASGN.FK_REBUILD_COMPO_ASGN_ISC |
TableName | REBUILD_COMPO_ASGN |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IONSRC.FK_REBUILD_COMPO_ASGN_ISC ON IONSRC.REBUILD_COMPO_ASGN(COMPO_ID) TABLESPACE ionsrc_ts      LOGGING ; |
REBUILD_COMPO_ASGN.FK_REBUILD_COMPO_ASGN_ISC Index Columns |
ColumnName | Sort Order |
COMPO_ID | Ascending |
REBUILD_COMPO_ASGN.FK_REBUILD_COMPO_ASGN_ISC Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
REBUILD_COMPO_ASGN.FK_REBUILD_COMPO_ASGN_ISC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
REBUILD_COMPO_ASGN.FK_REBUILD_COMPO_ASGN_ISC Bound Attachments |
Name | Current Value |
REBUILD_COMPO_ASGN.FK_REBUILD_COMPO_ASGN_RP |
TableName | REBUILD_COMPO_ASGN |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IONSRC.FK_REBUILD_COMPO_ASGN_RP ON IONSRC.REBUILD_COMPO_ASGN(REBUILD_ID) TABLESPACE ionsrc_ts      LOGGING ; |
REBUILD_COMPO_ASGN.FK_REBUILD_COMPO_ASGN_RP Index Columns |
ColumnName | Sort Order |
REBUILD_ID | Ascending |
REBUILD_COMPO_ASGN.FK_REBUILD_COMPO_ASGN_RP Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
REBUILD_COMPO_ASGN.FK_REBUILD_COMPO_ASGN_RP Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
REBUILD_COMPO_ASGN.FK_REBUILD_COMPO_ASGN_RP Bound Attachments |
Name | Current Value |
REBUILD_PHASE.PK_REBUILD_PHASE |
TableName | REBUILD_PHASE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
REBUILD_PHASE.PK_REBUILD_PHASE Index Columns |
ColumnName | Sort Order |
REBUILD_ID | Ascending |
REBUILD_PHASE.PK_REBUILD_PHASE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
REBUILD_PHASE.PK_REBUILD_PHASE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
REBUILD_PHASE.PK_REBUILD_PHASE Bound Attachments |
Name | Current Value |
REBUILD_PHASE.FK_REBUILD_PHASE_MCC |
TableName | REBUILD_PHASE |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IONSRC.FK_REBUILD_PHASE_MCC ON IONSRC.REBUILD_PHASE(MAG_CON_CONF_ID) TABLESPACE ionsrc_ts      LOGGING ; |
REBUILD_PHASE.FK_REBUILD_PHASE_MCC Index Columns |
ColumnName | Sort Order |
MAG_CON_CONF_ID | Ascending |
REBUILD_PHASE.FK_REBUILD_PHASE_MCC Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
REBUILD_PHASE.FK_REBUILD_PHASE_MCC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
REBUILD_PHASE.FK_REBUILD_PHASE_MCC Bound Attachments |
Name | Current Value |
REBUILD_PHASE.FK_REBUILD_PHASE_LEBTC |
TableName | REBUILD_PHASE |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IONSRC.FK_REBUILD_PHASE_LEBTC ON IONSRC.REBUILD_PHASE(LEBT_CONF_ID) TABLESPACE ionsrc_ts      LOGGING ; |
REBUILD_PHASE.FK_REBUILD_PHASE_LEBTC Index Columns |
ColumnName | Sort Order |
LEBT_CONF_ID | Ascending |
REBUILD_PHASE.FK_REBUILD_PHASE_LEBTC Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
REBUILD_PHASE.FK_REBUILD_PHASE_LEBTC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
REBUILD_PHASE.FK_REBUILD_PHASE_LEBTC Bound Attachments |
Name | Current Value |
REBUILD_PHASE.FK_REBUILD_PHASE_IST |
TableName | REBUILD_PHASE |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IONSRC.FK_REBUILD_PHASE_IST ON IONSRC.REBUILD_PHASE(ION_SRC_TYPE_ID) TABLESPACE ionsrc_ts      LOGGING ; |
REBUILD_PHASE.FK_REBUILD_PHASE_IST Index Columns |
ColumnName | Sort Order |
ION_SRC_TYPE_ID | Ascending |
REBUILD_PHASE.FK_REBUILD_PHASE_IST Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
REBUILD_PHASE.FK_REBUILD_PHASE_IST Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
REBUILD_PHASE.FK_REBUILD_PHASE_IST Bound Attachments |
Name | Current Value |
REBUILD_PHASE_NOTE.PK_REBUILD_PHASE_NOTE |
TableName | REBUILD_PHASE_NOTE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
REBUILD_PHASE_NOTE.PK_REBUILD_PHASE_NOTE Index Columns |
ColumnName | Sort Order |
REBUILD_ID | Ascending |
COMPO_ID | Ascending |
REBUILD_PHASE_NOTE.PK_REBUILD_PHASE_NOTE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
REBUILD_PHASE_NOTE.PK_REBUILD_PHASE_NOTE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
REBUILD_PHASE_NOTE.PK_REBUILD_PHASE_NOTE Bound Attachments |
Name | Current Value |
REBUILD_PHASE_NOTE.FK_REBUILD_PHASE_NOTE_RCA |
TableName | REBUILD_PHASE_NOTE |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX IONSRC.FK_REBUILD_PHASE_NOTE_RCA ON IONSRC.REBUILD_PHASE_NOTE(REBUILD_ID, COMPO_ID) TABLESPACE ionsrc_ts      LOGGING ; |
REBUILD_PHASE_NOTE.FK_REBUILD_PHASE_NOTE_RCA Index Columns |
ColumnName | Sort Order |
REBUILD_ID | Ascending |
COMPO_ID | Ascending |
REBUILD_PHASE_NOTE.FK_REBUILD_PHASE_NOTE_RCA Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | ionsrc_ts |
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 |
REBUILD_PHASE_NOTE.FK_REBUILD_PHASE_NOTE_RCA Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
REBUILD_PHASE_NOTE.FK_REBUILD_PHASE_NOTE_RCA Bound Attachments |
Name | Current Value |