清理索引和统计信息代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】清理索引和统计信息

作者:Dezai.CN / 发布于2011/11/22/ 797

<div>
<p class="MsoNormal" align="left"><span lang="EN-US">-----------------------------------------------</span>
<p class="MsoNormal" align="left"><span lang="EN-US">--</span><span>功能：清理索引和统计信息</span>
<p class="MsoNormal" align="left"><span lang="EN-US">--</span><span>时间：年月日</span>
<p class="MsoNormal" align="left"><span lang="EN-US">-----------------------------------------------</span>
<p class="MsoNormal" align="left">
<p class="MsoNormal" align="left">
<p class="MsoNormal" align="left"><span lang="EN-US">USE</span><span lang="EN-US"><span style="color: rgb(0,0,0)"> [MASTER]</span></span>
<p class="MsoNormal" align="left"><span lang="EN-US"><span style="color: rgb(0,0,0)">GO</span></span>
<p class="MsoNormal" align="left"><span lang="EN-US">/****** </span><span>对象</span><span lang="EN-US">:<span> </span>StoredProcedure [dbo].[spCleanIdx]<span> </span></span><span>脚本日期</span><span lang="EN-US">: 10/26/2008 20:06:57 ******/</span>
<p class="MsoNormal" align="left"><span lang="EN-US">SET</span><span lang="EN-US"><span style="color: rgb(0,0,0)"> </span><span>ANSI_NULLS</span><span style="color: rgb(0,0,0)"> </span><span>ON</span></span>
<p class="MsoNormal" align="left"><span lang="EN-US"><span style="color: rgb(0,0,0)">GO</span></span>
<p class="MsoNormal" align="left"><span lang="EN-US">SET</span><span lang="EN-US"><span style="color: rgb(0,0,0)"> </span><span>QUOTED_IDENTIFIER</span><span style="color: rgb(0,0,0)"> </span><span>ON</span></span>
<p class="MsoNormal" align="left"><span lang="EN-US"><span style="color: rgb(0,0,0)">GO</span></span>
<p class="MsoNormal" align="left"><span lang="EN-US">CREATE</span><span lang="EN-US"><span style="color: rgb(0,0,0)"> </span><span>PROCEDURE</span><span style="color: rgb(0,0,0)"> [dbo]</span><span>.</span><span style="color: rgb(0,0,0)">[spCleanIdx]</span></span>
<p class="MsoNormal" align="left"><span lang="EN-US"><span style="color: rgb(0,0,0)">@tabname </span><span>nvarchar</span><span>(</span><span style="color: rgb(0,0,0)">150</span><span>)</span><span style="color: rgb(0,0,0)"> </span><span>-- </span></span><span>需要删除统计或索引的表</span>
<p class="MsoNormal" align="left"><span lang="EN-US">AS</span>
<p class="MsoNormal" align="left">
<p class="MsoNormal" align="left"><span lang="EN-US">/*</span>
<p class="MsoNormal" align="left"><span>建立新的存储过程</span>
<p class="MsoNormal" align="left"><span lang="EN-US">*/</span>
<p class="MsoNormal" align="left">
<p class="MsoNormal" align="left"><span lang="EN-US">DECLARE</span><span lang="EN-US"><span style="color: rgb(0,0,0)"> @idx_name<span> </span></span><span>nvarchar</span><span>(</span><span style="color: rgb(0,0,0)">150</span><span>)</span><span style="color: rgb(0,0,0)"> </span><span>-- </span></span><span>存放要删除的索引或统计的名称</span>
<p class="MsoNormal" align="left"><span lang="EN-US">DECLARE</span><span lang="EN-US"><span style="color: rgb(0,0,0)"> @drop_idx_string </span><span>nvarchar</span><span>(</span><span style="color: rgb(0,0,0)">200</span><span>)</span><span style="color: rgb(0,0,0)"> </span><span>-- </span></span><span>存放动态组织而成的</span><span lang="EN-US">DROPS<span> </span>index/stats </span><span>语法</span>
<p class="MsoNormal" align="left">
<p class="MsoNormal" align="left"><span lang="EN-US">--SET NOCOUNT ON</span>
</div>

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

　清理索引　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)