ATTACHMENT.ATTACHMENT_PK |
TableName | ATTACHMENT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
ATTACHMENT.ATTACHMENT_PK Index Columns |
ColumnName | Sort Order |
ATTACHMENT_ID | Ascending |
ATTACHMENT.ATTACHMENT_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
ATTACHMENT.ATTACHMENT_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
ATTACHMENT.ATTACHMENT_PK Bound Attachments |
Name | Current Value |
ATTACHMENT_TYPE.ATTACHMENT_TYPE_PK |
TableName | ATTACHMENT_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
ATTACHMENT_TYPE.ATTACHMENT_TYPE_PK Index Columns |
ColumnName | Sort Order |
ATTACHMENT_TYPE_ID | Ascending |
ATTACHMENT_TYPE.ATTACHMENT_TYPE_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
ATTACHMENT_TYPE.ATTACHMENT_TYPE_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
ATTACHMENT_TYPE.ATTACHMENT_TYPE_PK Bound Attachments |
Name | Current Value |
DAILY_ORDER_REQD_READ.DAILY_ORDER_PK |
TableName | DAILY_ORDER_REQD_READ |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
DAILY_ORDER_REQD_READ.DAILY_ORDER_PK Index Columns |
ColumnName | Sort Order |
LOG_ENTRY_ID | Ascending |
DAILY_ORDER_REQD_READ.DAILY_ORDER_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
DAILY_ORDER_REQD_READ.DAILY_ORDER_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
DAILY_ORDER_REQD_READ.DAILY_ORDER_PK Bound Attachments |
Name | Current Value |
ENTRY_LOGBOOK.ENTRY_LOGBOOK_PK |
TableName | ENTRY_LOGBOOK |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
ENTRY_LOGBOOK.ENTRY_LOGBOOK_PK Index Columns |
ColumnName | Sort Order |
LOG_ENTRY_ID | Ascending |
LOGBOOK_ID | Ascending |
ENTRY_LOGBOOK.ENTRY_LOGBOOK_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
ENTRY_LOGBOOK.ENTRY_LOGBOOK_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
ENTRY_LOGBOOK.ENTRY_LOGBOOK_PK Bound Attachments |
Name | Current Value |
IMAGE.IMAGE_PK |
TableName | IMAGE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
IMAGE.IMAGE_PK Index Columns |
ColumnName | Sort Order |
IMAGE_ID | Ascending |
IMAGE.IMAGE_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
IMAGE.IMAGE_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
IMAGE.IMAGE_PK Bound Attachments |
Name | Current Value |
IMAGE_TYPE.IMAGE_TYPE_PK |
TableName | IMAGE_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
IMAGE_TYPE.IMAGE_TYPE_PK Index Columns |
ColumnName | Sort Order |
IMAGE_TYPE_ID | Ascending |
IMAGE_TYPE.IMAGE_TYPE_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
IMAGE_TYPE.IMAGE_TYPE_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
IMAGE_TYPE.IMAGE_TYPE_PK Bound Attachments |
Name | Current Value |
INSTR.INSTR_GRP_IND |
TableName | INSTR |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | PK_INSTR |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
INSTR.INSTR_GRP_IND Index Columns |
ColumnName | Sort Order |
INSTR_ID | Ascending |
INSTR.INSTR_GRP_IND 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 | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
INSTR.INSTR_GRP_IND Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INSTR.INSTR_GRP_IND Bound Attachments |
Name | Current Value |
INSTR.FK_INSTR_EXPT_FACIL |
TableName | INSTR |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX XF_ADMIN.FK_INSTR_EXPT_FACIL ON XF_ADMIN.INSTR(FACIL_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              ) ; |
INSTR.FK_INSTR_EXPT_FACIL Index Columns |
ColumnName | Sort Order |
FACIL_ID | Ascending |
INSTR.FK_INSTR_EXPT_FACIL 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 | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
INSTR.FK_INSTR_EXPT_FACIL Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INSTR.FK_INSTR_EXPT_FACIL 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_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 | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
INSTR.PK_INSTR Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
INSTR.PK_INSTR Bound Attachments |
Name | Current Value |
LOG_CATEGORIES.LOG_CATEGORIES_PK |
TableName | LOG_CATEGORIES |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LOG_CATEGORIES.LOG_CATEGORIES_PK Index Columns |
ColumnName | Sort Order |
CAT_ID | Ascending |
LOG_CATEGORIES.LOG_CATEGORIES_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
LOG_CATEGORIES.LOG_CATEGORIES_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_CATEGORIES.LOG_CATEGORIES_PK Bound Attachments |
Name | Current Value |
LOG_ENTRY.IDX_PRNT_LOG_ENTRY_ID |
TableName | LOG_ENTRY |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX LOGBOOK.IDX_PRNT_LOG_ENTRY_ID ON LOGBOOK.LOG_ENTRY(PRNT_LOG_ENTRY_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE LOGBOOK      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
LOG_ENTRY.IDX_PRNT_LOG_ENTRY_ID Index Columns |
ColumnName | Sort Order |
PRNT_LOG_ENTRY_ID | Ascending |
LOG_ENTRY.IDX_PRNT_LOG_ENTRY_ID Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
LOG_ENTRY.IDX_PRNT_LOG_ENTRY_ID Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY.IDX_PRNT_LOG_ENTRY_ID Bound Attachments |
Name | Current Value |
LOG_ENTRY.LOG_ENTRY_PK |
TableName | LOG_ENTRY |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LOG_ENTRY.LOG_ENTRY_PK Index Columns |
ColumnName | Sort Order |
LOG_ENTRY_ID | Ascending |
LOG_ENTRY.LOG_ENTRY_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
LOG_ENTRY.LOG_ENTRY_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY.LOG_ENTRY_PK Bound Attachments |
Name | Current Value |
LOG_ENTRY.ORIG_POST_IDX |
TableName | LOG_ENTRY |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX LOGBOOK.ORIG_POST_IDX ON LOGBOOK.LOG_ENTRY(ORIG_POST)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE LOGBOOK      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
LOG_ENTRY.ORIG_POST_IDX Index Columns |
ColumnName | Sort Order |
ORIG_POST | Ascending |
LOG_ENTRY.ORIG_POST_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
LOG_ENTRY.ORIG_POST_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY.ORIG_POST_IDX Bound Attachments |
Name | Current Value |
LOG_ENTRY_ATTACHMENT.LOG_ENTRY_ATTACHMENT_PK |
TableName | LOG_ENTRY_ATTACHMENT |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX LOGBOOK.LOG_ENTRY_ATTACHMENT_PK ON LOGBOOK.LOG_ENTRY_ATTACHMENT(ATTACHMENT_ID, LOG_ENTRY_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE LOGBOOK      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
LOG_ENTRY_ATTACHMENT.LOG_ENTRY_ATTACHMENT_PK Index Columns |
ColumnName | Sort Order |
ATTACHMENT_ID | Ascending |
LOG_ENTRY_ID | Ascending |
LOG_ENTRY_ATTACHMENT.LOG_ENTRY_ATTACHMENT_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
LOG_ENTRY_ATTACHMENT.LOG_ENTRY_ATTACHMENT_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY_ATTACHMENT.LOG_ENTRY_ATTACHMENT_PK Bound Attachments |
Name | Current Value |
LOG_ENTRY_BOOKMARK.LOG_ENTRY_BOOKMARK_PK |
TableName | LOG_ENTRY_BOOKMARK |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LOG_ENTRY_BOOKMARK.LOG_ENTRY_BOOKMARK_PK Index Columns |
ColumnName | Sort Order |
LOG_ENTRY_ID | Ascending |
BN | Ascending |
LOG_ENTRY_BOOKMARK.LOG_ENTRY_BOOKMARK_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
LOG_ENTRY_BOOKMARK.LOG_ENTRY_BOOKMARK_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY_BOOKMARK.LOG_ENTRY_BOOKMARK_PK Bound Attachments |
Name | Current Value |
LOG_ENTRY_CATEGORIES.CAT_ID_IDX |
TableName | LOG_ENTRY_CATEGORIES |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE BITMAP INDEX LOGBOOK.CAT_ID_IDX ON LOGBOOK.LOG_ENTRY_CATEGORIES(CAT_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE LOGBOOK      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
LOG_ENTRY_CATEGORIES.CAT_ID_IDX Index Columns |
ColumnName | Sort Order |
CAT_ID | Ascending |
LOG_ENTRY_CATEGORIES.CAT_ID_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | Bitmap |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
LOG_ENTRY_CATEGORIES.CAT_ID_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY_CATEGORIES.CAT_ID_IDX Bound Attachments |
Name | Current Value |
LOG_ENTRY_CATEGORIES.LOG_ENTRY_ID_IDX |
TableName | LOG_ENTRY_CATEGORIES |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX LOGBOOK.LOG_ENTRY_ID_IDX ON LOGBOOK.LOG_ENTRY_CATEGORIES(LOG_ENTRY_ID)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE LOGBOOK      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
LOG_ENTRY_CATEGORIES.LOG_ENTRY_ID_IDX Index Columns |
ColumnName | Sort Order |
LOG_ENTRY_ID | Ascending |
LOG_ENTRY_CATEGORIES.LOG_ENTRY_ID_IDX Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
LOG_ENTRY_CATEGORIES.LOG_ENTRY_ID_IDX Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY_CATEGORIES.LOG_ENTRY_ID_IDX Bound Attachments |
Name | Current Value |
LOG_ENTRY_IMAGE.LOG_ENTRY_IMAGE_PK |
TableName | LOG_ENTRY_IMAGE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LOG_ENTRY_IMAGE.LOG_ENTRY_IMAGE_PK Index Columns |
ColumnName | Sort Order |
IMAGE_ID | Ascending |
LOG_ENTRY_ID | Ascending |
LOG_ENTRY_IMAGE.LOG_ENTRY_IMAGE_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
LOG_ENTRY_IMAGE.LOG_ENTRY_IMAGE_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY_IMAGE.LOG_ENTRY_IMAGE_PK Bound Attachments |
Name | Current Value |
LOG_ENTRY_KEYWORD.LOG_ENTRY_KEYWORD_PK |
TableName | LOG_ENTRY_KEYWORD |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LOG_ENTRY_KEYWORD.LOG_ENTRY_KEYWORD_PK Index Columns |
ColumnName | Sort Order |
LOG_KEYWORD_ID | Ascending |
LOG_ENTRY_ID | Ascending |
LOG_ENTRY_KEYWORD.LOG_ENTRY_KEYWORD_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
LOG_ENTRY_KEYWORD.LOG_ENTRY_KEYWORD_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY_KEYWORD.LOG_ENTRY_KEYWORD_PK Bound Attachments |
Name | Current Value |
LOG_ENTRY_LABEL.PK_LOG_ENTRY_LABEL |
TableName | LOG_ENTRY_LABEL |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LOG_ENTRY_LABEL.PK_LOG_ENTRY_LABEL Index Columns |
ColumnName | Sort Order |
LABEL_ID | Ascending |
LOG_ENTRY_LABEL.PK_LOG_ENTRY_LABEL Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
LOG_ENTRY_LABEL.PK_LOG_ENTRY_LABEL Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY_LABEL.PK_LOG_ENTRY_LABEL Bound Attachments |
Name | Current Value |
LOG_ENTRY_NOTIF.LOG_ENTRY_NOTIF_PK |
TableName | LOG_ENTRY_NOTIF |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LOG_ENTRY_NOTIF.LOG_ENTRY_NOTIF_PK Index Columns |
ColumnName | Sort Order |
LOG_ENTRY_ID | Ascending |
BN | Ascending |
LOG_ENTRY_NOTIF.LOG_ENTRY_NOTIF_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
LOG_ENTRY_NOTIF.LOG_ENTRY_NOTIF_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY_NOTIF.LOG_ENTRY_NOTIF_PK Bound Attachments |
Name | Current Value |
LOG_ENTRY_PRIOR.LOG_ENTRY_PRIOR_PK |
TableName | LOG_ENTRY_PRIOR |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LOG_ENTRY_PRIOR.LOG_ENTRY_PRIOR_PK Index Columns |
ColumnName | Sort Order |
PRIOR_ID | Ascending |
LOG_ENTRY_PRIOR.LOG_ENTRY_PRIOR_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
LOG_ENTRY_PRIOR.LOG_ENTRY_PRIOR_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY_PRIOR.LOG_ENTRY_PRIOR_PK Bound Attachments |
Name | Current Value |
LOG_ENTRY_RAD_AREA.PK_LOG_ENTRY_RAD_AREA |
TableName | LOG_ENTRY_RAD_AREA |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LOG_ENTRY_RAD_AREA.PK_LOG_ENTRY_RAD_AREA Index Columns |
ColumnName | Sort Order |
LOG_ENTRY_ID | Ascending |
AREA_ID | Ascending |
LOG_ENTRY_RAD_AREA.PK_LOG_ENTRY_RAD_AREA Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
LOG_ENTRY_RAD_AREA.PK_LOG_ENTRY_RAD_AREA Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY_RAD_AREA.PK_LOG_ENTRY_RAD_AREA Bound Attachments |
Name | Current Value |
LOG_ENTRY_READ.IDX_LOG_ENTRY_READ_DTE |
TableName | LOG_ENTRY_READ |
Physical Only | NO |
PK/UK Constraint Name | |
Unique | NO |
Clustered Option | NON-CLUSTERED |
IndexType | Index |
DDL Code | CREATE INDEX LOGBOOK.IDX_LOG_ENTRY_READ_DTE ON LOGBOOK.LOG_ENTRY_READ(READ_DTE)      PCTFREE 10      INITRANS 2      MAXTRANS 255      TABLESPACE LOGBOOK      LOGGING      STORAGE(INITIAL 64K              NEXT 1024K              MINEXTENTS 1              MAXEXTENTS UNLIMITED              PCTINCREASE 0              BUFFER_POOL DEFAULT              ) ; |
LOG_ENTRY_READ.IDX_LOG_ENTRY_READ_DTE Index Columns |
ColumnName | Sort Order |
READ_DTE | Ascending |
LOG_ENTRY_READ.IDX_LOG_ENTRY_READ_DTE Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
LOG_ENTRY_READ.IDX_LOG_ENTRY_READ_DTE Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY_READ.IDX_LOG_ENTRY_READ_DTE Bound Attachments |
Name | Current Value |
LOG_ENTRY_READ.LOG_ENTRY_READ_PK |
TableName | LOG_ENTRY_READ |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LOG_ENTRY_READ.LOG_ENTRY_READ_PK Index Columns |
ColumnName | Sort Order |
LOG_ENTRY_ID | Ascending |
BN | Ascending |
LOG_ENTRY_READ.LOG_ENTRY_READ_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
LOG_ENTRY_READ.LOG_ENTRY_READ_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY_READ.LOG_ENTRY_READ_PK Bound Attachments |
Name | Current Value |
LOG_ENTRY_TYPE.LOG_ENTRY_TYPE_PK |
TableName | LOG_ENTRY_TYPE |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LOG_ENTRY_TYPE.LOG_ENTRY_TYPE_PK Index Columns |
ColumnName | Sort Order |
TYPE_ID | Ascending |
LOG_ENTRY_TYPE.LOG_ENTRY_TYPE_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
LOG_ENTRY_TYPE.LOG_ENTRY_TYPE_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY_TYPE.LOG_ENTRY_TYPE_PK Bound Attachments |
Name | Current Value |
LOG_KEYWORD.LOG_KEYWORD_PK |
TableName | LOG_KEYWORD |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LOG_KEYWORD.LOG_KEYWORD_PK Index Columns |
ColumnName | Sort Order |
LOG_KEYWORD_ID | Ascending |
LOG_KEYWORD.LOG_KEYWORD_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
LOG_KEYWORD.LOG_KEYWORD_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_KEYWORD.LOG_KEYWORD_PK Bound Attachments |
Name | Current Value |
LOGBOOK_USER_CAT.LOGBOOK_USER_CAT_PK |
TableName | LOGBOOK_USER_CAT |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
LOGBOOK_USER_CAT.LOGBOOK_USER_CAT_PK Index Columns |
ColumnName | Sort Order |
USER_CAT_ID | Ascending |
LOGBOOK_USER_CAT.LOGBOOK_USER_CAT_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
LOGBOOK_USER_CAT.LOGBOOK_USER_CAT_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOGBOOK_USER_CAT.LOGBOOK_USER_CAT_PK Bound Attachments |
Name | Current Value |
REQD_READ_FREQ.REQ_READ_FREQ_PK |
TableName | REQD_READ_FREQ |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
REQD_READ_FREQ.REQ_READ_FREQ_PK Index Columns |
ColumnName | Sort Order |
REQD_READ_FREQ_ID | Ascending |
REQD_READ_FREQ.REQ_READ_FREQ_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
REQD_READ_FREQ.REQ_READ_FREQ_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
REQD_READ_FREQ.REQ_READ_FREQ_PK Bound Attachments |
Name | Current Value |
USER_LOG_ENTRY_FLTR.PK_USR_LOG_ENTRY_FLTR |
TableName | USER_LOG_ENTRY_FLTR |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | PK_USER_LOG_ENTRY_FLTR |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
USER_LOG_ENTRY_FLTR.PK_USR_LOG_ENTRY_FLTR Index Columns |
ColumnName | Sort Order |
BN | Ascending |
USER_LOG_ENTRY_FLTR.PK_USR_LOG_ENTRY_FLTR Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
USER_LOG_ENTRY_FLTR.PK_USR_LOG_ENTRY_FLTR Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
USER_LOG_ENTRY_FLTR.PK_USR_LOG_ENTRY_FLTR Bound Attachments |
Name | Current Value |
USER_LOGIN.PK_USER_LOGIN |
TableName | USER_LOGIN |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
USER_LOGIN.PK_USER_LOGIN Index Columns |
ColumnName | Sort Order |
BN | Ascending |
USER_LOGIN.PK_USER_LOGIN Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | Logged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
USER_LOGIN.PK_USER_LOGIN Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
USER_LOGIN.PK_USER_LOGIN Bound Attachments |
Name | Current Value |
USER_SUBSCR.USER_SUBSCR_PK |
TableName | USER_SUBSCR |
Physical Only | NO |
Disabled | NO |
NoValidate | NO |
PK/UK Constraint Name | LOG_ENTRY_SUBSCR_PK |
Unique | YES |
Clustered Option | NON-CLUSTERED |
IndexType | PrimaryKey |
DDL Code |
USER_SUBSCR.USER_SUBSCR_PK Index Columns |
ColumnName | Sort Order |
BN | Ascending |
EQUIP_CAT_ID | Ascending |
USER_SUBSCR.USER_SUBSCR_PK Properties |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 64 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
NO SORT | NO |
Type | B-Tree |
Byte Order | Forward |
Logging | NotLogged |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | FreeLists |
FREELIST GROUPS | FreeList Groups |
Buffer Pool | DEFAULT |
Index Compression | NO |
USER_SUBSCR.USER_SUBSCR_PK Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
USER_SUBSCR.USER_SUBSCR_PK Bound Attachments |
Name | Current Value |