create nonclustered index score_ind on xs(total).sql

在学习SQL Server过程中整理的T-SQL语句

use test
if exists(select name from sysindexes where name='score_ind')
     drop index XS.score_ind
go
create nonclustered index score_ind on XS(total)
       with fillfactor=3
go