1.建立表student,字段id为主键,系统自动为之创建主键索引 create table student (id varchar2(10),name varchar2(8),sex varchar2(2),constraint id_stu primary key (id));
2.为name字段建立唯一索引 create unique index stu_uniq on student(name);
3.为sex字段建立位图索引 create bitmap index stu_bm on student(sex);