AXIS.PK_AXIS |
TableName | AXIS |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
AXIS.PK_AXIS Index Columns |
ColumnName | Sort Order |
AXIS_ID | Ascending |
AXIS.PK_AXIS 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 |
AXIS.PK_AXIS Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
AXIS.PK_AXIS Bound Attachments |
Name | Current Value |
AXIS.PK_AXIS_DATA_TYPE |
TableName | AXIS |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE UNIQUE INDEX DIAG.PK_AXIS_DATA_TYPE ON DIAG.AXIS(AXIS_ID)      LOGGING      STORAGE(BUFFER_POOL DEFAULT              ) ; |
AXIS.PK_AXIS_DATA_TYPE Index Columns |
ColumnName | Sort Order |
AXIS_ID | Ascending |
AXIS.PK_AXIS_DATA_TYPE 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 |
AXIS.PK_AXIS_DATA_TYPE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
AXIS.PK_AXIS_DATA_TYPE Bound Attachments |
Name | Current Value |
CHART_AXIS_DEF.PK_CHART_AXIS_DEF |
TableName | CHART_AXIS_DEF |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
CHART_AXIS_DEF.PK_CHART_AXIS_DEF Index Columns |
ColumnName | Sort Order |
CHART_ID | Ascending |
AXIS_ID | Ascending |
CHART_AXIS_DEF.PK_CHART_AXIS_DEF 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 |
CHART_AXIS_DEF.PK_CHART_AXIS_DEF Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
CHART_AXIS_DEF.PK_CHART_AXIS_DEF Bound Attachments |
Name | Current Value |
CHART_AXIS_INTVRL.PK_CHART_AXIS_INTVRL |
TableName | CHART_AXIS_INTVRL |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
CHART_AXIS_INTVRL.PK_CHART_AXIS_INTVRL Index Columns |
ColumnName | Sort Order |
INTVRL_TYPE_ID | Ascending |
CHART_AXIS_INTVRL.PK_CHART_AXIS_INTVRL 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 |
CHART_AXIS_INTVRL.PK_CHART_AXIS_INTVRL Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
CHART_AXIS_INTVRL.PK_CHART_AXIS_INTVRL Bound Attachments |
Name | Current Value |
CHART_AXIS_TYPE.PK_CHART_AXIS_TYPE |
TableName | CHART_AXIS_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
CHART_AXIS_TYPE.PK_CHART_AXIS_TYPE Index Columns |
ColumnName | Sort Order |
AXIS_TYPE_ID | Ascending |
CHART_AXIS_TYPE.PK_CHART_AXIS_TYPE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_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 |
CHART_AXIS_TYPE.PK_CHART_AXIS_TYPE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
CHART_AXIS_TYPE.PK_CHART_AXIS_TYPE Bound Attachments |
Name | Current Value |
CHART_DATA_DEF.PK_CHART_DATA_DEF |
TableName | CHART_DATA_DEF |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
CHART_DATA_DEF.PK_CHART_DATA_DEF Index Columns |
ColumnName | Sort Order |
DATA_DEF_ID | Ascending |
CHART_DATA_DEF.PK_CHART_DATA_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 |
CHART_DATA_DEF.PK_CHART_DATA_DEF Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
CHART_DATA_DEF.PK_CHART_DATA_DEF Bound Attachments |
Name | Current Value |
CHART_DATA_DEF_ASSC.PK_CHART_DATA_DEF_ASSC |
TableName | CHART_DATA_DEF_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
CHART_DATA_DEF_ASSC.PK_CHART_DATA_DEF_ASSC Index Columns |
ColumnName | Sort Order |
CHART_ID | Ascending |
DATA_DEF_ID | Ascending |
CHART_DATA_DEF_ASSC.PK_CHART_DATA_DEF_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 |
CHART_DATA_DEF_ASSC.PK_CHART_DATA_DEF_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
CHART_DATA_DEF_ASSC.PK_CHART_DATA_DEF_ASSC Bound Attachments |
Name | Current Value |
CHART_DATA_DEF_SERIES_ASSC.PK_CHART_DATA_DEF_SERIES_ASSC |
TableName | CHART_DATA_DEF_SERIES_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
CHART_DATA_DEF_SERIES_ASSC.PK_CHART_DATA_DEF_SERIES_ASSC Index Columns |
ColumnName | Sort Order |
SERIES_ID | Ascending |
DATA_DEF_ID | Ascending |
CHART_DATA_DEF_SERIES_ASSC.PK_CHART_DATA_DEF_SERIES_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 |
CHART_DATA_DEF_SERIES_ASSC.PK_CHART_DATA_DEF_SERIES_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
CHART_DATA_DEF_SERIES_ASSC.PK_CHART_DATA_DEF_SERIES_ASSC Bound Attachments |
Name | Current Value |
CHART_OPTION.PK_CHART_OPTION |
TableName | CHART_OPTION |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
CHART_OPTION.PK_CHART_OPTION Index Columns |
ColumnName | Sort Order |
OPTION_ID | Ascending |
CHART_OPTION.PK_CHART_OPTION 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 |
CHART_OPTION.PK_CHART_OPTION Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
CHART_OPTION.PK_CHART_OPTION Bound Attachments |
Name | Current Value |
DIAG_CHART.PK_DIAG_CHART |
TableName | DIAG_CHART |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
DIAG_CHART.PK_DIAG_CHART Index Columns |
ColumnName | Sort Order |
CHART_ID | Ascending |
DIAG_CHART.PK_DIAG_CHART 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 |
DIAG_CHART.PK_DIAG_CHART Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DIAG_CHART.PK_DIAG_CHART Bound Attachments |
Name | Current Value |
DIAG_CHART_CHART_OPT_ASSC.PK_DIAG_CHART_CHART_OPT_ASSC |
TableName | DIAG_CHART_CHART_OPT_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
DIAG_CHART_CHART_OPT_ASSC.PK_DIAG_CHART_CHART_OPT_ASSC Index Columns |
ColumnName | Sort Order |
CHART_ID | Ascending |
OPTION_ID | Ascending |
DIAG_CHART_CHART_OPT_ASSC.PK_DIAG_CHART_CHART_OPT_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 |
DIAG_CHART_CHART_OPT_ASSC.PK_DIAG_CHART_CHART_OPT_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DIAG_CHART_CHART_OPT_ASSC.PK_DIAG_CHART_CHART_OPT_ASSC Bound Attachments |
Name | Current Value |
DIAG_CHART_MATH_FUNC_ASGN.PK_CHART_MATH_FUNC_ASGN |
TableName | DIAG_CHART_MATH_FUNC_ASGN |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
DIAG_CHART_MATH_FUNC_ASGN.PK_CHART_MATH_FUNC_ASGN Index Columns |
ColumnName | Sort Order |
FUNC_ID | Ascending |
CHART_ID | Ascending |
DIAG_CHART_MATH_FUNC_ASGN.PK_CHART_MATH_FUNC_ASGN 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 |
DIAG_CHART_MATH_FUNC_ASGN.PK_CHART_MATH_FUNC_ASGN Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DIAG_CHART_MATH_FUNC_ASGN.PK_CHART_MATH_FUNC_ASGN Bound Attachments |
Name | Current Value |
DIAG_REP.PK_DIAG_REP |
TableName | DIAG_REP |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
DIAG_REP.PK_DIAG_REP Index Columns |
ColumnName | Sort Order |
REP_ID | Ascending |
DIAG_REP.PK_DIAG_REP Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_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 |
DIAG_REP.PK_DIAG_REP Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DIAG_REP.PK_DIAG_REP Bound Attachments |
Name | Current Value |
DIAG_REP_OPTION.PK_REP_OPTION |
TableName | DIAG_REP_OPTION |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
DIAG_REP_OPTION.PK_REP_OPTION Index Columns |
ColumnName | Sort Order |
OPT_ID | Ascending |
DIAG_REP_OPTION.PK_REP_OPTION 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 |
DIAG_REP_OPTION.PK_REP_OPTION Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DIAG_REP_OPTION.PK_REP_OPTION Bound Attachments |
Name | Current Value |
DIAG_REPT_TAG.PK_DIAG_REPT_TAG |
TableName | DIAG_REPT_TAG |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
DIAG_REPT_TAG.PK_DIAG_REPT_TAG Index Columns |
ColumnName | Sort Order |
TAG_ID | Ascending |
DIAG_REPT_TAG.PK_DIAG_REPT_TAG 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 |
DIAG_REPT_TAG.PK_DIAG_REPT_TAG Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DIAG_REPT_TAG.PK_DIAG_REPT_TAG Bound Attachments |
Name | Current Value |
DIAG_REPT_TMPL.PK_DIAG_REPT_TMPL |
TableName | DIAG_REPT_TMPL |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
DIAG_REPT_TMPL.PK_DIAG_REPT_TMPL Index Columns |
ColumnName | Sort Order |
TMPL_ID | Ascending |
DIAG_REPT_TMPL.PK_DIAG_REPT_TMPL 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 |
DIAG_REPT_TMPL.PK_DIAG_REPT_TMPL Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DIAG_REPT_TMPL.PK_DIAG_REPT_TMPL Bound Attachments |
Name | Current Value |
DIAG_RPT_CHART_ASSC.PK1146 |
TableName | DIAG_RPT_CHART_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
DIAG_RPT_CHART_ASSC.PK1146 Index Columns |
ColumnName | Sort Order |
REP_ID | Ascending |
CHART_ID | Ascending |
DIAG_RPT_CHART_ASSC.PK1146 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 |
DIAG_RPT_CHART_ASSC.PK1146 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DIAG_RPT_CHART_ASSC.PK1146 Bound Attachments |
Name | Current Value |
DIAG_SGNL_REC.PK_DIAG_SGNL_REC |
TableName | DIAG_SGNL_REC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
DIAG_SGNL_REC.PK_DIAG_SGNL_REC Index Columns |
ColumnName | Sort Order |
SGNL_ID | Ascending |
DIAG_SGNL_REC.PK_DIAG_SGNL_REC Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_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 |
DIAG_SGNL_REC.PK_DIAG_SGNL_REC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DIAG_SGNL_REC.PK_DIAG_SGNL_REC Bound Attachments |
Name | Current Value |
MATH_FUNC.PK1095 |
TableName | MATH_FUNC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
MATH_FUNC.PK1095 Index Columns |
ColumnName | Sort Order |
FUNC_ID | Ascending |
MATH_FUNC.PK1095 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 |
MATH_FUNC.PK1095 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
MATH_FUNC.PK1095 Bound Attachments |
Name | Current Value |
REP_DIST.PK_REP_DIST |
TableName | REP_DIST |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
REP_DIST.PK_REP_DIST Index Columns |
ColumnName | Sort Order |
BN | Ascending |
REP_ID | Ascending |
REP_DIST.PK_REP_DIST 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 |
REP_DIST.PK_REP_DIST Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
REP_DIST.PK_REP_DIST Bound Attachments |
Name | Current Value |
REP_OPT_DIAG_REP_ASSC.PK_REP_OPT_DIAG_REP_ASSC |
TableName | REP_OPT_DIAG_REP_ASSC |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
REP_OPT_DIAG_REP_ASSC.PK_REP_OPT_DIAG_REP_ASSC Index Columns |
ColumnName | Sort Order |
OPT_ID | Ascending |
REP_ID | Ascending |
REP_OPT_DIAG_REP_ASSC.PK_REP_OPT_DIAG_REP_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 |
REP_OPT_DIAG_REP_ASSC.PK_REP_OPT_DIAG_REP_ASSC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
REP_OPT_DIAG_REP_ASSC.PK_REP_OPT_DIAG_REP_ASSC Bound Attachments |
Name | Current Value |
SERIES.PK_SERIES |
TableName | SERIES |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SERIES.PK_SERIES Index Columns |
ColumnName | Sort Order |
SERIES_ID | Ascending |
SERIES.PK_SERIES 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 |
SERIES.PK_SERIES Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SERIES.PK_SERIES Bound Attachments |
Name | Current Value |
SERIES_CHART_AXIS_ASGN.PK_SERIES_CHART_AXIS_ASGN |
TableName | SERIES_CHART_AXIS_ASGN |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SERIES_CHART_AXIS_ASGN.PK_SERIES_CHART_AXIS_ASGN Index Columns |
ColumnName | Sort Order |
SERIES_ID | Ascending |
CHART_ID | Ascending |
AXIS_ID | Ascending |
SERIES_CHART_AXIS_ASGN.PK_SERIES_CHART_AXIS_ASGN 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 |
SERIES_CHART_AXIS_ASGN.PK_SERIES_CHART_AXIS_ASGN Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SERIES_CHART_AXIS_ASGN.PK_SERIES_CHART_AXIS_ASGN Bound Attachments |
Name | Current Value |
SERIES_MATH_FUNC_ASGN.PK_SERIES_MATH_FUNC_ASGN |
TableName | SERIES_MATH_FUNC_ASGN |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SERIES_MATH_FUNC_ASGN.PK_SERIES_MATH_FUNC_ASGN Index Columns |
ColumnName | Sort Order |
SERIES_ID | Ascending |
FUNC_ID | Ascending |
SERIES_MATH_FUNC_ASGN.PK_SERIES_MATH_FUNC_ASGN 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 |
SERIES_MATH_FUNC_ASGN.PK_SERIES_MATH_FUNC_ASGN Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SERIES_MATH_FUNC_ASGN.PK_SERIES_MATH_FUNC_ASGN Bound Attachments |
Name | Current Value |
SERIES_SGNL_REC_ASGN.PK_SERIES_SGNL_REC_ASGN |
TableName | SERIES_SGNL_REC_ASGN |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
SERIES_SGNL_REC_ASGN.PK_SERIES_SGNL_REC_ASGN Index Columns |
ColumnName | Sort Order |
SERIES_ID | Ascending |
SGNL_ID | Ascending |
SERIES_SGNL_REC_ASGN.PK_SERIES_SGNL_REC_ASGN 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 |
SERIES_SGNL_REC_ASGN.PK_SERIES_SGNL_REC_ASGN Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
SERIES_SGNL_REC_ASGN.PK_SERIES_SGNL_REC_ASGN Bound Attachments |
Name | Current Value |
STAT_IMG.PK_STAT_IMG |
TableName | STAT_IMG |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
STAT_IMG.PK_STAT_IMG Index Columns |
ColumnName | Sort Order |
REP_ID | Ascending |
CUR_DTE | Ascending |
STAT_IMG.PK_STAT_IMG 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 |
STAT_IMG.PK_STAT_IMG Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
STAT_IMG.PK_STAT_IMG Bound Attachments |
Name | Current Value |
STAT_IMG.PK_REP_PDF_1 |
TableName | STAT_IMG |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE UNIQUE INDEX DIAG.PK_REP_PDF_1 ON DIAG.STAT_IMG(REP_ID, CUR_DTE)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE DIAG_TS      LOGGING      STORAGE(INITIAL 256K              NEXT 256K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              FREELISTS 1              FREELIST GROUPS 1              BUFFER_POOL DEFAULT              ) ; |
STAT_IMG.PK_REP_PDF_1 Index Columns |
ColumnName | Sort Order |
REP_ID | Ascending |
CUR_DTE | Ascending |
STAT_IMG.PK_REP_PDF_1 Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | DIAG_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 |
STAT_IMG.PK_REP_PDF_1 Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
STAT_IMG.PK_REP_PDF_1 Bound Attachments |
Name | Current Value |