如何维护我的数据库？ [英] How is the maintenance of my databases ?

问题描述

当增加输入数据库的数据量时。效率会降低。我该怎么办？

When increasing the amount of data entered into the database .What leads to a decrease in efficiency .What can I do?

推荐答案

请阅读这些和你'找到如何在Sql中优化数据访问，我希望它能帮到你..

http://www.dotnet-tricks.com/Tutorial/sqlserver/bM6H260812-Tips-to-improve-SQL-Server- database-design-and-performance.html [ ^ ]

优化SQL Server中数据访问的十大步骤：第一部分（使用索引） [ ^ ]

优化SQL Server数据访问的十大步骤：第二部分（重新考虑TSQL并应用最佳实践） [ ^ ]

Please Read these and you'll find How to optimize Data Access in Sql,and i hope it'll help you..
http://www.dotnet-tricks.com/Tutorial/sqlserver/bM6H260812-Tips-to-improve-SQL-Server-database-design-and-performance.html[^]
Top 10 steps to optimize data access in SQL Server: Part I (use indexing)[^]
Top 10 steps to optimize data access in SQL Server: Part II (Re-factor TSQL and apply best practices)[^]

糟糕的表格布局

缺少索引和未优化的sql语句

等

poor table layout
lack of index and unoptimized sql statement
and etc.

这篇关于如何维护我的数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！