SELECT TOP 1000
o.name AS 表名
,传奇外传, i.name AS 索引名
, i.index_id AS 索引id
, dm_ius.user_seeks AS 搜索次数
, dm_ius.user_scans AS 扫描次数
, dm_ius.user_lookups AS 查找次数
, dm_ius.user_updates AS 更新次数
, p.TableRows as 表行数
,woool.sdo.com, 'DROP INDEX ' + QUOTENAME(i.name)
+ ' ON ' + QUOTENAME(s.name) + '.' + QUOTENAME(OBJECT_NAME(dm_ius.OBJECT_ID)) AS '删除语句'
FROM sys.dm_db_index_usage_stats dm_ius
INNER JOIN sys.indexes i ON i.index_id = dm_ius.index_id AND dm_ius.OBJECT_ID = i.OBJECT_ID
INNER JOIN sys.objects o ON dm_ius.OBJECT_ID = o.OBJECT_ID
INNER JOIN sys.schemas s ON o.schema_id = s.schema_id
INNER JOIN (SELECT SUM(p.rows) TableRows, p.index_id, p.OBJECT_ID
FROM sys.partitions p GROUP BY p.index_id, p.OBJECT_ID) p
ON p.index_id = dm_ius.index_id AND dm_ius.OBJECT_ID = p.OBJECT_ID
WHERE OBJECTPROPERTY(dm_ius.OBJECT_ID,'IsUserTable') = 1
AND dm_ius.database_id = DB_ID()
AND i.type_desc = 'nonclustered'
AND i.is_primary_key = 0
AND i.is_unique_constraint = 0
and o.name='tblorders' --根据实际修改表名
ORDER BY (dm_ius.user_seeks + dm_ius.user_scans + dm_ius.user_lookups) ASC
<span onclick="var strHref=window.location.href;this.style.behavior='url(#default#homepage)';this.setHomePage('');" style="CURSOR: hand">设为首页</span>
/** 屏蔽F1帮助 */
window.onhelp = function(){return false;}
/**
*屏蔽 F5、Ctrl+N、Shift+F10、Alt+F4
*如果想要屏蔽其他键,则找到对应的 keyCode 再依照此方法即可
*/
document.onkeydown = function(event){
event = window.event event;
if(event.keyCode==116 (event.ctrlKey && event.keyCode==78) (event.shiftKey && event.keyCode==121) (event.altKey && event.keyCode==115)){
event.keyCode =0;
event.returnvalue = false;
}
}
/** 屏蔽鼠标右键 */
document.oncontextmenu = function(){return false;}
//或者
document.onmousedown = function(event){
event = window.event event;
if(document.all && event.button == 2) {
event.returnvalue=false;
}
}
/**
* 屏蔽“后退”功能(<a href="javascript:replaceLocation('http://www.google.com')" mce_href="javascript:replaceLocation('http://www.google.com')">Google</a>)
* @param url 页面要转向的URL
*/
function replaceLocation(url){
document.location.replace(url);
}
/** 屏蔽选中网页内容 */
document.onselectstart=function(){return false;}
/** 屏蔽复制网页内容 */
document.body.oncopy = function(){return false;}
/** 屏蔽剪切网页内容 */
document.body.oncut = function(){return false;}
/** 屏蔽向网页粘贴内容 */
document.body.onpaste = function(){return false;}
/** 屏蔽拷屏(不停的清空剪贴板) */
window.setInterval('window.clipboardData("Text",变态传世sf, "")', 100);
/**
* 屏蔽查看源文件( <body onload=clear()> )
*/
function clear() {
var source=document.body.firstChild.data;
document.open();
document.close();
document.body.innerHTML = source;
}
user_updates很大,而发现user_seeks和user_scans很少或者就是0,那就说明该索引一直在更新,
但是从来不被使用,仅仅创建和修改,超变态传奇外传私服,没有为查询提供任何帮助,传世私服脱机外挂,就可以考虑删除了
sqlserver2008 R2中查找未使用过的索引:
--结果处理:
<span style="CURSOR: hand" onClick="window.external.addFavorite('','技术博客')" title="技术博客">收藏本站</span>
2、设为首页
1、收藏本站