索引

 

/* 在视图建立索引，将 ansi_nulls,ansi_padding,ansi_warnings,

concat_null_yields_null,quoted_identifier 设置为 on, 将 numeric_roundabort 设置为 off*/

use school

go

set ansi_nulls,ansi_padding,ansi_warnings,concat_null_yields_null,

    quoted_identifier on;

set numeric_roundabort off

create     unique    clustered   index idx_v_student_idx

on    v_student_idx(id)

go