Description
noneIndex properties
| name | value |
|---|
| name | JESSE.PO_ZIP_XMLIDX
|
| size | kb |
| type | unknown
|
| parent | PURCHASEORDER
|
| 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 |
|---|
| PORDER
| 1
| ascending
|
Dependency graph
Objects that JESSE.PO_ZIP_XMLIDX depends on
Code
CREATE INDEX "JESSE "."PO_ZIP_XMLIDX" ON "JESSE "."PURCHASEORDER"
("PORDER" ASC)
GENERATE KEY USING XMLPATTERN '/PurchaseOrder/customerAdr/addr/pcode-zip'
AS SQL VARCHAR ( 16 ) IGNORE INVALID VALUES
COMPRESS NO ALLOW REVERSE SCANS;