SqlServer 建立索引

--在adgroup表创建索引：

USE ds_api
GO
IF EXISTS (SELECT name FROM sysindexes

          WHERE name = 'IX_adgroup')

   DROP INDEX adgroup.IX_adgroup

CREATE NONCLUSTERED INDEX IX_adgroup

     ON adgroup(client_name,advertiser_name,campaign_id,campaign_name,adgroup_id,adgroup_name,[pause],[status],default_cpc_price,placement,negative_keyword,pv,clicks,cost,[rank],rpm)

GO