创建索引oracle 很慢,为什么加了索引执行更慢了呢？解决办法

SQL code-- Create table

create table T_GG_MOBILENO_SENDABLE

(

sendable_id NUMBER(10) not null,

mobileno_id NUMBER(10),

mobileno NUMBER(11),

mobileno_kind NUMBER(4),

mobileno_age NUMBER(4),

mobileno_money NUMBER(8),

mobileno_area NVARCHAR2(6),

mobileno_sex NUMBER(1),

mobileno_double NUMBER(1),

mobileno_treble NUMBER(1)

)

tablespace GXT

pctfree 10

pctused 40

initrans 1

maxtrans 255

storage

(

initial 64K

minextents 1

maxextents unlimited

);

-- Create/Recreate indexes

create index INDEX_T_GG_MOBILENO_AGE on T_GG_MOBILENO_SENDABLE (MOBILENO_AGE)

tablespace GXT

pctfree 10

initrans 2

maxtrans 255

storage

(

initial 64K

minextents 1

maxextents unlimit