Index: USER.XACT3

Properties

Name: XACT3 
Schema: USER 
Table schema: USER 
Table: ACT 
Unique rule: DUBLICATE 
Type: REGULAR 
Create time: 05.07.2006 
Tablespace: USERSPACE1 
Description:  

Columns

Colname Order
  ACTNO  ASCENDING 
  ACTKWD  ASCENDING 
  ACTDESC  ASCENDING 
Total: 3 column(s)

Autherisations

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

SQL

CREATE INDEX "USER    "."XACT3" ON "USER    "."ACT"
        ("ACTNO" ASC,
         "ACTKWD" ASC,
         "ACTDESC" ASC) ALLOW REVERSE SCANS;

See Also

List of indexes