因此，项目计划应该包含数据库优化活动的时间和资源。
Therefore, the project plan should include the necessary time and resources for database specific tuning activities.
最优数据库性能还需要数据库优化器很好地发挥作用。
Optimal database performance requires the database optimizer to do its job well.
表之间的关系提供了Teradata数据库优化器的输入值。
Relationships between tables provide valuable input to the Teradata database optimizer.
但是，为了通过数据库优化获得最大的收益，您需要了解两件事。
But to get the most out of your database optimization efforts, there are two things that you need to know.
分析了ORACLE三数据库优化的方法和系统工具。
The paper analyses the method and tool of the ORACLE database.
数据库优化器为数据库查询提供一个最佳的执行策略。
The database optimizer provides an optimal executive strategy for database query.
讨论了在大型关系数据库优化设计中关系的规范化和逆规范化的应用。
In this paper, the application of normalization and denormalization in the optimization of relational database design are discussed.
数据库优化很快会成为一个前沿话题，我几乎没有空间在这里完全公正地做这个话题。
Database optimization can become a pretty advanced topic quickly, and I don't have nearly the space here to do this topic full justice.
增量式数据库作为一种全新的数据库优化技术，在各种具有流数据特点的场合具有广阔的前景。
As a brand new optimization technique, incremental database can be widely used in variety of occasions with data stream features.
同样地，应用程序设计也能调优性能：更少的对象创建、实时的数据库优化以及使用数据库连接池。
Similarly the application design can be tuned for performance: Fewer object creations, ongoing database refinements, and using database connection pooling.
如果查询的创建是通过先添加维度再添加事实表然后又添加维度的方式构成，那么数据库优化则必须包含实体化。
If the query was written by adding a dimension followed by a fact and then another dimension, then the database optimization would include the materialization as necessary.
分析了影响数据库性能的各方面因素，以及数据库优化应遵循的方法，并就数据库优化技术方法进行了探讨。
The paper analyzes the factors that affect the performances of database, lists the principles that database should obey, and finally explores the methods of database optimization.
在下一篇文章中，我将介绍一些实用技巧，您可以使用这些技巧来为另一个真实世界中的Rails示例进行数据库优化。
In the next article, I'll write about some tricks that we use to do database optimization for another example of real world Rails.
通常，数据库问题可能是指由数据库导致的任何瓶颈问题，包括SQL查询、数据库优化参数、索引问题和数据分布问题。
Generally, database problems can refer to any bottleneck due to database, including SQL queries, database tuning parameters, indexing issues, and data distribution problems.
但正像其他数据库技术一样，原生xml数据库将让那些知道如何优化系统以提高效率和响应性的公司获得最大的收益。
But just like any other database technology, native XML databases will provide the most benefit to those who understand well how to optimize their systems for efficiency and responsiveness.
更新数据库服务器用于优化查询的系统编目表。
Update system catalog tables that the database server USES to optimize queries.
在理想情况下，数据库会选择最“优化”的访问计划——也就是最高效最快地返回数据的计划。
Ideally, the database chooses the most "optimal" access plan — that is, the plan that returns the data most efficiently and quickly.
因此，数据库必须针对读写操作优化。
Therefore, the databases must be optimized for read and write operations.
检查是否对数据库进行过优化。
在当今的经济环境中，数据库性能和成本优化的重要性和价值怎么强调也不过分。
In the current economic climate, the immediate need for and value of database performance cost optimization and tuning cannot be overstated.
最后，您将了解如何对查询进行分析以优化数据库的性能。
Finally, you'll see how you can profile your queries to optimize the performance of your database.
紧凑的数据表可以针对基于行的数据库做存储块优化，让SQL执行得更好。
Compact tables can optimize storage blocks for row-based databases and accordingly make SQL perform better.
当查询准备好后，数据库将分析、编译和优化执行该查询的计划。
When the query is prepared, the database will analyze, compile and optimize it's plan for executing the query.
为了优化数据库，您可以添加索引。
通常使用这种方法来优化数据库服务器。
This is how you would have normally tuned your database server.
可能会请求您优化数据库。
在处理数据库时，查询优化至关重要，而UPDATESTATISTICS正是用于此目的。
Query optimization is crucial in dealing with databases, and UPDATE STATISTICS does just that.
Design Advisor 非常适合为数据仓库优化数据库设计，因为除了关于索引的建议之外，它还可以提供关于MQT、MDC和DPF分区键的建议。
The Design Advisor is well suited for optimizing database design for data warehouses as it provides advice on MQTs, MDCs, and DPF partitioning keys in addition to indexes.
Design Advisor 非常适合为数据仓库优化数据库设计，因为除了关于索引的建议之外，它还可以提供关于MQT、MDC和DPF分区键的建议。
The Design Advisor is well suited for optimizing database design for data warehouses as it provides advice on MQTs, MDCs, and DPF partitioning keys in addition to indexes.
应用推荐