Index: XCF_I_HANDLE_STATUS on table XCF
Index: XCF_I_HANDLE_STATUS on table XCF
| Name: | XCF_I_HANDLE_STATUS |
| Table: | XCF |
| Type: | NORMAL |
| Unique: | NONUNIQUE |
| Tablespace: | TOOLS |
| Status: | VALID |
| Descend: | ASC |
| Table owner: | RMAN |
| Temporary: | No |
| Join Index: | No |
| Initial extent size: | 65536 |
| Secondary extent size: | |
| Min extents: | 1 |
| Max extents: | 2147483645 |
| Percent encrease: | |
| Distinct keys: |
| Name | Length | Descend | |
|
|
HANDLE_HASHKEY | 30 | ASC |
|
|
STATUS | 1 | ASC |
CREATE INDEX "RMAN"."XCF_I_HANDLE_STATUS" ON "RMAN"."XCF" ("HANDLE_HASHKEY", "STATUS")
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "TOOLS"
See Also
List of indexes