Index: ASN.IBMSNAP_SUBS_MEMBX
Index: ASN.IBMSNAP_SUBS_MEMBX
| Name: | IBMSNAP_SUBS_MEMBX |
| Schema: | ASN |
| Table schema: | ASN |
| Table: | IBMSNAP_SUBS_MEMBR |
| Unique rule: | UNIQUE |
| Type: | REGULAR |
| Create time: | 01.07.2006 |
| Tablespace: | TSASNAA |
| Description: |
| Colname | Order | |
|
|
APPLY_QUAL | ASCENDING |
|
|
SET_NAME | ASCENDING |
|
|
WHOS_ON_FIRST | ASCENDING |
|
|
SOURCE_OWNER | ASCENDING |
|
|
SOURCE_TABLE | ASCENDING |
|
|
SOURCE_VIEW_QUAL | ASCENDING |
|
|
TARGET_OWNER | ASCENDING |
|
|
TARGET_TABLE | ASCENDING |
| Grantor | Grantee | Authorities | |
|
|
SYSIBM | USER | CONTROL=HELD |
CREATE UNIQUE INDEX "ASN "."IBMSNAP_SUBS_MEMBX" ON "ASN "."IBMSNAP_SUBS_MEMBR"
("APPLY_QUAL" ASC,
"SET_NAME" ASC,
"WHOS_ON_FIRST" ASC,
"SOURCE_OWNER" ASC,
"SOURCE_TABLE" ASC,
"SOURCE_VIEW_QUAL" ASC,
"TARGET_OWNER" ASC,
"TARGET_TABLE" ASC);
See Also
List of indexes