EMPLOYEE
我导出了Oracle DB 中表的DDL 。这个指数是什么?该索引适用于哪些列?
CREATE UNIQUE INDEX "MY_USER"."SYS_IL0000126968C00005$$" ON "MY_USER"."EMPLOYEE" (
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "DATA"
PARALLEL (DEGREE 0 INSTANCES 0) ;
该查询不显示上述索引。如何查询上述唯一索引?
select
TABLE_NAME,
INDEX_NAME,
UNIQUENESS,
NUM_ROWS,
CONSTRAINT_INDEX,
OWNER,
TABLE_OWNER
from
SYS.ALL_INDEXES;