string类型是一种特殊的序列，它允许语言使用它们的字符串库和优化。
The string type is a special sequence that will allow languages to leverage much of their string libraries and optimizations.
为了优化性能，每个活动数据库服务器任务应该有10MB内存。
For optimal performance, there should be 10mb of memory per active database server job.
如果查询的创建是通过先添加维度再添加事实表然后又添加维度的方式构成，那么数据库优化则必须包含实体化。
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.
基于蛋白质数据的固有特点，我们设计了一种优化的混合数据库模式。
Based on the intrinsic characteristics of the protein data, we have designed an optimized hybrid database schema.
更新数据库服务器用于优化查询的系统编目表。
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.
为了确保最优的数据库性能，需要确保数据库得到了全部的优化。
To ensure optimal database performance, it is necessary to ensure that the database is fully optimized.
针对单个问题的优化：本质上，层次数据库就通过一条指定的路径来优化数据访问。
Optimized for one problem: By their nature, hierarchical databases optimized access to the data through one specific path.
因此，数据库必须针对读写操作优化。
Therefore, the databases must be optimized for read and write operations.
数据库优化很快会成为一个前沿话题，我几乎没有空间在这里完全公正地做这个话题。
Database optimization can become a pretty advanced topic quickly, and I don't have nearly the space here to do this topic full justice.
但是，为了通过数据库优化获得最大的收益，您需要了解两件事。
But to get the most out of your database optimization efforts, there are two things that you need to know.
检查是否对数据库进行过优化。
您可能还会考虑您用来优化数据库访问的游标类型。
You might also want to consider the type of cursor you should use to optimize data access.
但是如果您在寻求优化您的数据库的速度，首先应当采取一些步骤，这应当对常见问题有所帮助。
But if you are looking at optimizing the speed of your database, there are a few steps that you should take first which should help the most common issues encountered.
通常使用这种方法来优化数据库服务器。
This is how you would have normally tuned your database server.
为了优化数据库，您可以添加索引。
访问方法是指优化器从数据库表中读取(更确切地说是检索)数据的方法。
Access methods refer to the ways that the optimizer reads (or rather retrieves) data from database tables.
最后，您将了解如何对查询进行分析以优化数据库的性能。
Finally, you'll see how you can profile your queries to optimize the performance of your database.
与优化数据库服务器有所不同，对于NFS来说，您希望允许VMM使用尽可能多的RAM来进行NFS数据缓存。
Unlike when you tune database servers, with NFS you want to allow the VMM to use as much RAM as possible for NFS data caching.
程序本身的其他方面，比如数据库操作已经进行了优化。
Aspects of the program itself, such as database operations, were already tuned.
紧凑的数据表可以针对基于行的数据库做存储块优化，让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.
数据库服务器再度优化指定过程中的sql语句。
The database server re-optimizes SQL statements in the named procedure.
因此，项目计划应该包含数据库优化活动的时间和资源。
Therefore, the project plan should include the necessary time and resources for database specific tuning activities.
对于一个真正的测试来说，要使用已经针对自己的环境优化过的库。
For a true test, get libraries that have been optimized for your environment.
通常，数据库问题可能是指由数据库导致的任何瓶颈问题，包括SQL查询、数据库优化参数、索引问题和数据分布问题。
Generally, database problems can refer to any bottleneck due to database, including SQL queries, database tuning parameters, indexing issues, and data distribution problems.
服务存储库经过了优化，能存储大量资产和支持大量用户进行临时查询来查找这些资产。
The service repository is optimized for store large amounts of assets and to enable a large user population to make ad-hoc queries to find these assets.
查询优化器使用数据库中的SYSSTAT目录视图来检索数据库对象的统计信息，并确定访问数据库的最佳方法。
The query optimizer USES the SYSSTAT catalog views in the database to retrieve the statistical information of the database objects and determine the best way to access the data.
检查是否完成了数据库的优化。
同样地，应用程序设计也能调优性能：更少的对象创建、实时的数据库优化以及使用数据库连接池。
Similarly the application design can be tuned for performance: Fewer object creations, ongoing database refinements, and using database connection pooling.
应用推荐