第十章

create nonclustered index idx_student_name
    on student(student_name desc)
    go

create nonclustered index idx_student_sexbirthday
    on student(student_sex desc,student_birthday)
    with fillfactor = 60

create unique clustered index id_selectcourse_studentcourse
    on selectcourse(selectcourse_studentno,selectcourse_courseno)
    go

sp_helpindex student
go

sp_rename 'student.idx_student_name','idx_student_nameone'
go

create statistics idx_student_sex
    on student(student_no,student_name,student_sex)
    with sample 5 percent

drop index student.idx_student_sexbirthday
go


create unique nonclustered index idx_teacher_titleandno
    on teacher(teacher_titlecode,teacher_no desc)
    go
    sp_helpindex teacher
    go

create nonclustered index idx_teacher_departandname
    on teacher(teacher_departmentno desc,teacher_name)
    go
    sp_helpindex teacher
    go