create index idx_saleformula_saleno on saleformula(saleno)
--查看表所有索引
EXEC sp_helpindex 'saleformula'
--重建表的所有索引
DBCC DBREINDEX ('saleformula','')
--重建表索引碎片
DBCC INDEXDEFRAG ('shop_zhujiang','saleformula','idx_CreateUserCode')
DBCC INDEXDEFRAG ('shop_zhujiang','saleformula','idx_saleformula_buyer')
DBCC INDEXDEFRAG ('shop_zhujiang','saleformula','idx_saleformula_drugid')
DBCC INDEXDEFRAG ('shop_zhujiang','saleformula','idx_saleformula_fillor')
DBCC INDEXDEFRAG ('shop_zhujiang','saleformula','idx_saleformula_hospital')
DBCC INDEXDEFRAG ('shop_zhujiang','saleformula','idx_saleformula_saledate')
DBCC INDEXDEFRAG ('shop_zhujiang','saleformula','idx_saleFormula_saleno')
DBCC INDEXDEFRAG ('shop_zhujiang','saleformula','PK__saleFormula__294D0584')
--重建索引统计表
UPDATE STATISTICS saleformula
--查看表所有索引
EXEC sp_helpindex 'saleformula'
--重建表的所有索引
DBCC DBREINDEX ('saleformula','')
--重建表索引碎片
DBCC INDEXDEFRAG ('shop_zhujiang','saleformula','idx_CreateUserCode')
DBCC INDEXDEFRAG ('shop_zhujiang','saleformula','idx_saleformula_buyer')
DBCC INDEXDEFRAG ('shop_zhujiang','saleformula','idx_saleformula_drugid')
DBCC INDEXDEFRAG ('shop_zhujiang','saleformula','idx_saleformula_fillor')
DBCC INDEXDEFRAG ('shop_zhujiang','saleformula','idx_saleformula_hospital')
DBCC INDEXDEFRAG ('shop_zhujiang','saleformula','idx_saleformula_saledate')
DBCC INDEXDEFRAG ('shop_zhujiang','saleformula','idx_saleFormula_saleno')
DBCC INDEXDEFRAG ('shop_zhujiang','saleformula','PK__saleFormula__294D0584')
--重建索引统计表
UPDATE STATISTICS saleformula