create index IX_OR_PLANNING_GROUP_GID on ORDER_RELEASE (PLANNING_GROUP_GID)
tablespace INDX
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 1M
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
select t.*,i.index_type from user_ind_columns t,user_indexes i where t.index_name = i.index_name and t.table_name='ORDER_RELEASE'