create index aid on abin(id)
create unique index usid on abin(sid)
//组合索引
create unique index allindex on abin(id,name,sid)
http://blog.csdn.net/java05/article/details/5579183 创建主键：
create table abin1(
id number(10,0) not null check(id>0),
name nvarchar2(100),
constraint abin1id primary key(id)
);
创建主键和外键
create table abin2(
id number(10,0) not null check(id>0),
sid number(10,0) not null,
name nvarchar2(100),
constraint abin2id primary key(id),
constraint abin2sid foreign key(sid) references abin1(id)
)