查找并删除重复索引? [英] Finding and removing duplicate indexes?
问题描述
我正在使用SQL Server 2008,并且拥有一个包含超过150个具有重复索引的表的数据库。
I am using SQL Server 2008 and have a database with more than 150 tables that have duplicate indexes.
我发现了一些会列出重复索引的sql脚本,但我不确定我是否应该信任它们。据说,他们说我有400多个重复索引;我不确定这是否正确,因此不想使用它们来自动删除欺骗。
I found some sql scripts which will list the duplicate indexes, but I'm not sure if I should trust them. Supposedly, they are saying that I have over 400 duplicate indexes; I'm not sure if that is correct, and therefore don't want to use them to automatically remove dupes.
如何确定地找到重复的索引并删除它们?
How can I definitively locate duplicate indexes and remove them?
推荐答案
查看Tom LaRock的优秀如何查找重复索引博客文章 - 他详细解释了如何进行,并提供了检测重复索引的脚本。
Check out Tom LaRock's excellent How to Find Duplicate Indexes blog post - he explains in great detail how to go about, and also offers up scripts to detect duplicate indices.
这篇关于查找并删除重复索引?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!