Properties

Name: IBMSNAP_APPLYTRLX 
Schema: ASN 
Table schema: ASN 
Table: IBMSNAP_APPLYTRAIL 
Unique rule: DUBLICATE 
Type: REGULAR 
Create time: 01.07.2006 
Tablespace: TSASNAA 
Description:  

Columns

Colname Order
  LASTRUN  DESCENDING 
  APPLY_QUAL  ASCENDING 
Total: 2 column(s)

Autherisations

Grantor Grantee Authorities
  SYSIBM  USER  CONTROL=HELD 
Total: 1 autherisation(s)

SQL

CREATE INDEX "ASN     "."IBMSNAP_APPLYTRLX" ON "ASN     "."IBMSNAP_APPLYTRAIL"
        ("LASTRUN" DESC,
         "APPLY_QUAL" ASC);

See Also

List of indexes