This makes DB2 queries use table scans instead of index scans and degrades database performance.
这使得DB 2查询使用表扫描代替索引扫描，并降低了数据库的性能。
A buffer pool is an area of storage in memory into which database pages (containing table rows or index entries) are temporarily read and changed.
缓冲池是内存中的一块存储区域，用于临时读入和更改数据库页(包含表行或索引项)。
If there is an index on the join column, the costs will be significantly less; otherwise the database server must perform table scans for all tables, both outer and inner tables.
如果连接列上有一个索引，那么其成本会相当低；否则，数据库服务器就必须对所有表(外部和内部表)执行表扫描。
It queries your database, indexes each column in each row of the result, and ties each index entry to the row's primary key.
它将查询数据库，为结果的每行中的每列建立索引，并且将每个索引条目绑定到行的主键上。
Information about the column definitions, index, and statistics for a nickname is stored in the DB2 federated database system catalogs.
关于列定义、索引以及昵称统计信息的信息存储在DB 2联邦数据库系统编目中。
Physical database design includes table design, index design, materialized query table design, and the design of the other physical database objects.
物理数据库设计包括表设计、索引设计、物化查询表设计，以及其他物理数据库对象的设计。
From the table space snapshot data, the used page objects can be used to tell the total size of the index, tables, and the total database size.
从表空间快照数据中可以看出，这些用过的页面对象可用于告知索引、表和数据库的总大小。
Other table spaces for user, temporary and index data need to be created after the database has been created, and a user needs to be assigned to these table spaces before they can be used.
其他用于用户数据、临时数据和索引数据的表空间则需要在创建数据库之后另行创建，并且在使用这些表空间之前，还需要为之指定一个用户。
Develop a server add-on that automatically adds new and modified documents from the source database to the index database.
开发一个服务器附件，自动将新的和修改了的文档从源数据库添加到索引数据库。
The agent that updates the index database with new documents is currently rather slow and is not optimized, which can be fixed by adding a couple of tracking fields to the index documents.
使用新文档更新索引数据库的代理目前速度很慢，且未进行优化，通过添加一对跟踪字段到索引文档中就可以解决这一问题。
That results in a database selection wizard, wherein you allowed to choose the database where you want to perform various checks, namely database, data, index, logs, and space checks.
这会打开数据库选择向导，可以在此向导中选择要执行各种检查的数据库，比如数据库、数据、索引、日志和空间检查。
The database, on the other hand, is an easy place to make a few simple changes (add an index, change a query slightly) and see tremendous performance improvements.
另一方面，数据库是一个容 易做一些简单改变（添加一个索引，稍稍修改一个查询）并看到巨大性能改善的地方。
In 1996, WHO set up a global database on obesity and body mass index, the common measure of fatness.
1996年，世界卫生组织建立了一个肥胖和身体质量指数数据库，身体质量指数是衡量肥胖的通行标准。
The number of rows retrieved from the outer table after the database server applies any table filters is small, and the inner table has an index that can be used to perform the join.
在数据库服务器使用所有表筛选器之后，从外部表检索出的行数将很少，而内部表具有一个可用于执行连接的索引。
A database requiring an index that large is extreme and creates significant problems related to performance and database administration.
需要那么多索引的数据库的确称得上超大，这种数据库的性能和数据库管理是个很大的问题。
Disk access rates and configurations affect the speed of database and view opening and of opening and navigating a collection (view index).
磁盘访问率和配置影响数据库、视图打开和集合导航(查看索引)的速度。
Since a DB2 buffer pool is a part of the main memory of the system, the DB2 database manager allocates it for caching tables and index data when it reads or writes to and from media disks.
因为db2缓冲池是系统主内存的一部分，DB 2数据库管理器在它读取或写入磁盘介质时将它分配给缓存表和索引数据。
In addition to the RUNSTATS, you can automate database backups and REORGs (defragmentation of table and index data).
除了RUNSTATS外，还可以将数据库备份和REORG(表和索引数据整理)自动化。
According to the official request for information [PDF], NASA needs ideas on what format to use, how to index the notes and how to create a useful database.
根据官方的请求，美国宇航局需要如下的一些方案，如何整理此手稿的格式，如何对这些注解进行进行处理，使其整齐有序，以及如何据此创建一个可用的数据库。
The reason for this is that the other tables in the DB2 UDB SAMPLE database have no primary key, and hence no index information to associate a unique ECO key with.
原因是DB2UDBSAMPLE数据库中的其他表没有主键，因此没有索引信息可以关联惟一的ECO 键。
To be able to collect statistics against a table or index, one must be able to connect to the database that contains the tables and indexes and have one of the following authorization levels
为了可以对一个表或索引收集统计信息，必须能够连接到包含该表和索引的数据库，并具有下列授权级别之一
If users are allowed to search their archived mail, the fields CSLDOrigDB and main search criteria (like the Subject attribute) should also have a database index configured.
如果用户被允许搜索已归档的邮件，那么也应该为字段CSLDOrigDB和主要的搜索标准(如subject属性)配置数据库索引。
Initialize the index database and all the MKF databases (includes permanent, transient, and security databases). Enter the following commands to initialize the databases.
初始化索引数据库和所有MKF数据库(包括永久、临时和安全数据库)。
A source identifies the database to index, provides authentication information, and defines the query to use to construct each row.
source将标识数据库来建立索引，提供验证信息，并且定义查询用以构造每行。
Those details are not discussed here; instead this article describes the general idea and its adaptation to integrate a hash index into a database system using the DB2 index extension mechanism.
本文并不讨论这些细节，而是描述一般的思想，以及使用DB 2索引扩展机制将hash索引集成到数据库系统中。
Although Lucene is a search index, and not a database, if your fields are reasonably small, you can ask Lucene to store them in the index.
虽然Lucene是一个搜索索引而非一个数据库，但是如果这个字段相当小，你可以让Lucene把它们存在索引里面。
Compass extends core Lucene and adds transaction support and fast updates, as well as the ability to store the index in the database.
Compass扩展了核心lucene，增加了事务控制功能和快速更新，也包括在数据库存储索引的功能。
A ClearQuest FTS index will be dramatically smaller than a ClearQuest user database because it is storing only a dictionary of terms that are identified and referenced by Pointers.
ClearQuestFTS索引要比ClearQuest用户数据库小很多，因为它只存储指针识别及引用项目的字典。
Generally, after a redistribution of a database partition group, you need to perform an offline table reorg, index recreation (if necessary), and runstats on the redistributed table.
通常，在数据库分区组重分发之后，需要在重分发的表上执行离线的table reorg、indexrecreation(必要时)和runstats。
forcing locate to update the database/index is done with $ sudo updatedb, and it doesn’t take a lot of time
强制更新数据库/索引可使用$sudoupdatedb命令，这也花不了多少时间。
应用推荐