创建索引

 

 

--语法
CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ] INDEX index_name   
    ON <object> ( column_name [ ASC | DESC ] [ ,...n ] )   
    [ WITH <backward_compatible_index_option> [ ,...n ] ]  
    [ ON { filegroup_name | "default" } ]  


--创建索引
Create NONCLUSTERED  index  idx_BU9_GIDATE1  
ON  [tb_SAPData_BU9] (GIDATE)


--创建带有包含列的索引
Create index  idx_BU9_GIDATE  
ON  [tb_SAPData_BU9] (GIDATE)
INCLUDE (QPN,TYPE,ZTYDL)


--修改索引的参数
ALTER INDEX [PK_BU9] ON
    [tb_SAPData_BU9]
SET (

    ALLOW_PAGE_LOCKS = ON
    )
;