本文共 2061 字，大约阅读时间需要 6 分钟。

Oracle ?????????

Oracle ????

? Oracle ????????????????????????????????????????

?????????

1. ?????

????????????

CREATE TABLE indexTable (    ID VARCHAR2(10),    NAME VARCHAR2(20),    CONSTRAINT pk_id PRIMARY KEY (ID))ORGANIZATION INDEX;

2. ??????

?????????????????

CREATE INDEX idx_secondary_name ON indexTable (NAME);

3. ??????

?????????????

CREATE INDEX idx_reverse_id ON tbl_reverse_idx (id) REVERSE;

4. ??????

?????????????

CREATE BITMAP INDEX idx_secondary_name ON indexTable (NAME) BITMAP;

5. ??????

???????????????

CREATE INDEX idx_emp_ename_lower ON emp (LOWER(ename));

???????

1. ????

• ORA-28669?

  ?bitmap ??????? IOT ?????????
  ?????
  ?? IOT ??????????????

  ALTER TABLE indexTable MOVE MAPPING TABLE;

2. ????

• B-tree ?????

  • ?????????????????????????
  • ????????????????????????????

• ????????

  ??????????????????????????????

???????

1. ????

• ?????

  ALTER INDEX idx_name REBUILD ONLINE;

• ?????

  ALTER INDEX idx_name REBUILD PARTITION p2_idx_name;

2. ??????

• ?????

  ALTER INDEX idx_name USE NONE|INDEX;

• ??????

  ALTER INDEX idx_name UNUSABLE;

• ??????

  ALTER INDEX idx_name INVISIBLE|VISIBLE;

3. ????

• ???????

  SELECT * FROM V$OBJECT_USAGEWHERE INDEX_NAME = 'idx_name'AND TABLE_NAME = 'table_name';

Clustering Factor ??

• Clustering Factor?CF??
  CF ?????????????????????
  • ????? CF?? CF ?? 1000????????????
  • ??????????????????????

??????????? Oracle ??????????????????