ÇóOracleÖиø·ÖÇø±í½¨±¾µØË÷ÒýµÄÀý×Ó

  ÈçÌâ¡£

---

CREATE  BITMAP INDEX OPT_ACCRL_PROD_IFCT_BX1 ON OPT_ACCRL_PROD_IFCT
(ACCT_FUND_SKID  ASC)
NOLOGGING
NOPARALLEL
LOCAL ;

---

ÒýÓÃ

CREATE BITMAP INDEX OPT_ACCRL_PROD_IFCT_BX1 ON OPT_ACCRL_PROD_IFCT
(ACCT_FUND_SKID ASC)
NOLOGGING
NOPARALLEL
LOCAL ;

  λͼË÷Òý£¿

---

SQL code:
ops$tkyte@ORA10G> CREATE TABLE partitioned_table
2 ( a int,
3 b int,
4 data char(20)
5 )
6 PARTITION BY RANGE (a)
7 (
8 PARTITION part_1 VALUES LESS THAN(2) tablespace p1,
9 PARTITION part_2 VALUES LESS THAN(3) tablespace p2
10 )
11 /
Table created.

ops$tkyte@ORA10G> create index local_prefixed on partitioned_table (a,b) local;
Index created.
ops$tkyte@ORA10G> create index local_nonprefixed on partitioned_table (b) local;
Index created.

---

¶÷£¬È¥µôBitmap¾ÍÊÇb-treeË÷ÒýÁË£¬Óï·¨Ò»Ñù

---

ÒýÓÃ

SQL codeops$tkyte@ORA10G>CREATETABLE partitioned_table2 ( aint,3 bint,4 datachar(20)5 )6 PARTITIONBY RANGE (a)7 (8 PARTITION part_1VALUES LESS THAN(2) tablespace p1,9 PARTITION part_2VALUES LESS THAN(3) tablespace p210 )11/Table created.

ops$tkyte@ORA10G>createindex local_prefixedon partitioned_table (a,b) local;Index created.
ops$tkyte@ORA10G>createindex local_nonprefixedon partition