Description
noneIndex properties
| name | value |
|---|
| name | JESSE.PROD_NAME_XMLIDX
|
| size | kb |
| type | unknown
|
| parent | PRODUCT
|
| 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 |
|---|
| DESCRIPTION
| 1
| ascending
|
Dependency graph
Objects that JESSE.PROD_NAME_XMLIDX depends on
Code
CREATE INDEX "JESSE "."PROD_NAME_XMLIDX" ON "JESSE "."PRODUCT"
("DESCRIPTION" ASC)
GENERATE KEY USING XMLPATTERN '/product/description/name'
AS SQL VARCHAR ( 128 ) IGNORE INVALID VALUES
COMPRESS NO ALLOW REVERSE SCANS;