normal index

---------------------

SQL> create table t2 (a number,b varchar2(10 char));

Table created.

SQL>
SQL>
SQL>
SQL> begin
2 for i in 1..100 loop
3 insert into t2 values(i,'adfsdfs'||to_char(i));
4 end loop;
5 end;
6 /

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL>
SQL>
SQL> commit;

Commit complete.

SQL>
SQL> create index idx_n_t2 on t2(a);

Index created.

SQL>
SQL>
SQL> set long 10000
SQL> select dbms_metadata.get_ddl('INDEX','IDX_N_T2') FROM DUAL;

DBMS_METADATA.GET_DDL('INDEX','IDX_N_T2')
--------------------------------------------------------------------------------

CREATE INDEX "MAGY"."IDX_N_T2" ON "MAGY"."T2" ("A")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "DATA01"

SQL>

----------------------------

bitmap index

create bitmap index idx_bm_t2 on t2(b);

----------------------------

partition index

create table t3
(a number,
b varchar2(10 char)
)
partition by range (a)
(partition p1 values less than (50),
partition p2 values less than (100));

CREATE INDEX MAGY.idx_pt_t3 ON MAGY.T3
(A)
LOCAL (
PARTITION P1,
PARTITION P2);

-----------------------------

unique index

SQL>
SQL> create unique index idx_uq_t2 on t2(a);

Index created.

SQL>

ITPub博客

index

最新文章