CREATE BITMAP INDEX OPT_ACCRL_PROD_IFCT_BX1 ON OPT_ACCRL_PROD_IFCT (ACCT_FUND_SKID ASC) NOLOGGING NOPARALLEL LOCAL ;
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索引了,语法一样
一个表有tab1有N个分区: 我在其中一个字段createtime上建一个本地索引行了吗: 比如:create index 索引名 on ptab1 (createtime) local;
(ACCT_FUND_SKID ASC)
NOLOGGING
NOPARALLEL
LOCAL ;
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.
我在其中一个字段createtime上建一个本地索引行了吗:
比如:create index 索引名 on ptab1 (createtime) local;