因此,项目计划应该包含数据库优化活动的时间和资源。
Therefore, the project plan should include the necessary time and resources for database specific tuning activities.
本文以实例介绍了智能数据库优化设计的过程。
Informations(including graphics and text type data)about chemical compositiont manufacture conditions and microstructure data for various kinds of materials were stored in the database.
最优数据库性能还需要数据库优化器很好地发挥作用。
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.
方法:通过分析现有系统的运行情况,采用硬件升级、软件修改和数据库优化的方式进行PACS优化。
Methods the PACS system was optimized with hardware upgrades, software modifications, and database optimization by analyzing the operation of the existing system.
分析了影响数据库性能的各方面因素,以及数据库优化应遵循的方法,并就数据库优化技术方法进行了探讨。
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.
更新数据库服务器用于优化查询的系统编目表。
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.
在处理数据库时,查询优化至关重要,而UPDATESTATISTICS正是用于此目的。
Query optimization is crucial in dealing with databases, and UPDATE STATISTICS does just that.
应用推荐