索引

 

/*在视图建立索引，将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