| name | value |
|---|---|
| name | JESSE.XEMP2 |
| size | 8 kb |
| type | regular index |
| parent | EMPLOYEE |
| 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 |
|---|---|---|
| WORKDEPT | 1 | ascending |
| name | object type | level |
|---|---|---|
| EMPLOYEE | table | 1 |
| name | object type | level |
|---|---|---|
| P0490587 | package | 1 |
| BONUS_INCREASE | stored procedure | 2 |
CREATE INDEX "JESSE "."XEMP2" ON "JESSE "."EMPLOYEE" ("WORKDEPT" ASC) COMPRESS NO ALLOW REVERSE SCANS;