If you are using SQL Server, you will benefit from the Database Engine Tuning Advisor. Quoted directly from TechNet, here are the capabilities:
Recommend the best mix of indexes for databases by using the query optimizer to analyze queries in a workload.
Recommend aligned or non-aligned partitions for databases referenced in a workload.
Recommend indexed views for databases referenced in a workload.
Analyze the effects of the proposed changes, including index usage, query distribution among tables, and query performance in the workload.
Recommend ways to tune the database for a small set of problem queries.
Allow you to customize the recommendation by specifying advanced options such as disk space constraints.
Provide reports that summarize the effects of implementing the recommendations for a given workload.
Consider alternatives in which you supply possible design choices in the form of hypothetical configurations for Database Engine Tuning Advisor to evaluate.
发布评论
评论（2）
如果您使用的是 SQL Server，您将受益于数据库引擎优化顾问。直接引用自 TechNet，以下是这些功能：
If you are using SQL Server, you will benefit from the Database Engine Tuning Advisor. Quoted directly from TechNet, here are the capabilities:
我不确定你正在使用什么数据库，但是当然，在 MySQL 中良好的第一步通常是使用 EXPLAIN 命令：
http://dev.mysql.com/doc/refman/5.0 /en/using-explain.html
有一系列第三方应用程序可以帮助使用 MySQL 进行数据库调整。例如 MONyog。
I am not sure what database you are using, but of course a good first start in MySQL is often to use the EXPLAIN command:
http://dev.mysql.com/doc/refman/5.0/en/using-explain.html
There are a collection of third party applications that assist with database tuning with MySQL. such as MONyog.