1、创建索引
语法:
creat [unique][clustered][nonclustered]index index_name on {table|view}(column[asc|desc][,...n])
[with<index_option>[,...n]]
[on filegroup]
<index_option>::=
{pad_index|
flllfactor=fillfactor|ignore_dup_key|drop_existing|statiscs_norecompute|sort_in_tempdb}
示例1:创建非聚集索引
use mr_sql
creat nonclustered index mr_sele_id_ind on mr_sele(id)
加上with fillfactor=100 就是创建了填充因子
示例2:创建组合索引