| name | value |
|---|---|
| name | JESSE.XDEPT3 |
| size | 8 kb |
| type | regular index |
| parent | DEPARTMENT |
| unique rule | duplicates allowed |
| created | 3/16/2010 8:49:02 PM |
| last statistics | 3/16/2010 9:07:31 PM |
| percent free | no statistics |
| leaf pages | 1 |
| density | 0 |
| levels | 1 |
| name | position | order |
|---|---|---|
| ADMRDEPT | 1 | ascending |
| name | object type | level |
|---|---|---|
| DEPARTMENT | table | 1 |
CREATE INDEX "JESSE "."XDEPT3" ON "JESSE "."DEPARTMENT" ("ADMRDEPT" ASC) COMPRESS NO ALLOW REVERSE SCANS;