{"id":340,"date":"2021-01-19T09:15:37","date_gmt":"2021-01-19T01:15:37","guid":{"rendered":"https:\/\/22pig.com\/?p=340"},"modified":"2021-01-19T09:15:37","modified_gmt":"2021-01-19T01:15:37","slug":"sql-server-%e5%a2%9e%e5%8a%a0%e7%b4%a2%e5%bc%95","status":"publish","type":"post","link":"http:\/\/22pig.com\/?p=340","title":{"rendered":"sql server \u589e\u52a0\u7d22\u5f15"},"content":{"rendered":"<p>SELECT TOP 30<br \/>\n[Total Cost] = ROUND(avg_total_user_cost * avg_user_impact * (user_seeks + user_scans),0)<br \/>\n, avg_user_impact<br \/>\n, TableName = statement<br \/>\n, [EqualityUsage] = equality_columns<br \/>\n, [InequalityUsage] = inequality_columns<br \/>\n, [Include Cloumns] = included_columns<br \/>\nFROM sys.dm_db_missing_index_groups g<br \/>\nINNER JOIN sys.dm_db_missing_index_group_stats s<br \/>\nON s.group_handle = g.index_group_handle<br \/>\nINNER JOIN sys.dm_db_missing_index_details d<br \/>\nON d.index_handle = g.index_handle<br \/>\nORDER BY [Total Cost] DESC;<\/p>\n<p>create index idx_siwfc on [hetecology].[dbo].[ShareInnerWfCreate]([isBelong], [usertype],[id], [workflowid], [content], [min_seclevel], [max_seclevel]);<br \/>\ncreate index idx_wfap on [hetecology].[dbo].[workflow_addinoperate]([isnode], [workflowid], [ispreadd]);<br \/>\ncreate index idx_ubmdt1 on [hetecology].[dbo].[uf_BO_MARA_dt1](id);<br \/>\ncreate index idx_otd on [hetecology].[dbo].[ofs_todo_data]([requestid], [isremark], [islasttimes]);<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SELECT TOP 30 [Total Cost] = ROUND(avg_total_user_cost * avg_user_impact * (user_seeks + user_scans),0) , avg_user_impact , TableName = statement , [EqualityUsage] = equality_columns , [InequalityUsage] = inequality_columns , [Include Cloumns] = included_columns FROM sys.dm_db_missing_index_groups g INNER JOIN sys.dm_db_missing_index_group_stats s ON s.group_handle = g.index_group_handle INNER JOIN sys.dm_db_missing_index_details d ON d.index_handle = g.index_handle ORDER BY [Total Cost] [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-340","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"_links":{"self":[{"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/posts\/340","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=340"}],"version-history":[{"count":0,"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/posts\/340\/revisions"}],"wp:attachment":[{"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=340"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=340"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}