如题。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.
