未使用的数据库表效果 [英] Unused Database Table Effects

问题描述

在我们的 SQL Server 数据库中，我们至少有 25-35 个从未使用过的查找/空表.将它们保留在我们的数据库中是否有任何负面影响(性能、存储等)

In our SQL Server Database we have at least 25-35 lookup / empty tables that are never used. Is there any negative effect for keeping them in our database (performance, storage etc)

基本上，删除它们会对查询等产生任何积极影响.

Basically, would deleteing them have any positive impact on queries etc.

推荐答案

如果查询不引用表，则不会对这些查询产生影响.SQL Server 会注意频繁请求的信息并将该信息缓存在内存中.有一个表应该不会导致性能或存储的显着差异.

If queries don't reference the tables, then there would be no impact to those queries. SQL Server will pay attention to frequently requested information and cache that information in memory. Having a table out there should result in no notable difference in performance or storage.

这篇关于未使用的数据库表效果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！