Description
noneIndex properties
| name | value |
|---|
| name | JESSE.CUST_PHONET_XMLIDX
|
| size | kb |
| type | unknown
|
| parent | CUSTOMER
|
| unique rule | duplicates allowed
|
| created | 3/16/2010 8:49:13 PM
|
| last statistics |
|
| percent free | no statistics |
| leaf pages | no statistics |
| density | no statistics |
| levels | no statistics |
Index columns
| name | position | order |
|---|
| INFO
| 1
| ascending
|
Dependency graph
Objects that JESSE.CUST_PHONET_XMLIDX depends on
Code
CREATE INDEX "JESSE "."CUST_PHONET_XMLIDX" ON "JESSE "."CUSTOMER"
("INFO" ASC)
GENERATE KEY USING XMLPATTERN '/customerinfo/phone/@type'
AS SQL VARCHAR ( 25 ) IGNORE INVALID VALUES
COMPRESS NO ALLOW REVERSE SCANS;