SqlServer 建立索引

发布时间：2020-12-12 14:13:11 所属栏目：MsSql教程来源：网络整理

导读：--在adgroup表创建索引： USE ds_apiGOIF EXISTS (SELECT name FROM sysindexes WHERE name = 'IX_adgroup') DROP INDEX adgroup.IX_adgroupCREATE NONCLUSTERED INDEX IX_adgroup ON adgroup(client_name,advertiser_name,campaign_id,campaign_name,adgrou

--在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

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!