如果你有足够的内存，请将该参数的值设置得尽可能大以显著减少索引时间。
If you have enough RAM, set the value of this parameter as large as possible to decrease the indexing time dramatically.
这个是很难避免的，除非索引足够小，可以加载到内存中。
This cannot easily be avoided unless the index is small enough to be loaded into RAM.
如果应用程序频繁地访问没有适当索引的小表，数据库每次都会把它们装载进内存并扫描它们。
If your application frequently accesses smaller tables without proper indexes, the database will load them into memory each time and scan them.
这将指示DB 2将索引键传递给内存中的排序程序，而不是再次将这些键写到DASD上的排序工作文件中，然后从中读取这些键。
This instructs DB2 to pass the index keys to the sort program in memory, rather than having the keys written to and read once again from sort work files on DASD.
所有数据库表和索引都放在内存中，而且永远不会保存到磁盘上。
All database tables and indexes are kept in memory and never saved to disk.
缓冲池是内存中的一块存储区域，用于临时读入和更改数据库页(包含表行或索引项)。
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.
它包括两个部分：一个内存地址以及一个索引寄存器。
这个设置控制NSF缓冲池的大小，后者是用于缓冲NIF索引函数与磁盘存储之间的I/O传输的一部分内存。
This setting controls the size of the NSF buffer pool, a section of memory dedicated to buffering I/O transfers between the NIF indexing functions and disk storage.
物理地址(处理器用于索引物理ram的地址)的大小限制了可以寻址的内存。
The size of the physical address (the address used by the processor to index physical RAM) limits the amount of memory that can be addressed.
根据索引、CPU以及可用内存的大小，这个过程可能需要较长的一段时间。
This process can take a long time based on the size of the index, the CPU, and the amount of memory available.
索引寄存器会与某个指定的地址相加，结果用作访问内存时使用的地址。
The index register is added to the specified address, and the result is used as the address for the memory access.
因为db2缓冲池是系统主内存的一部分，DB 2数据库管理器在它读取或写入磁盘介质时将它分配给缓存表和索引数据。
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.
这个参数的默认值是10，如果你有足够的内存，那么将这个值尽量设的比较大一些将会显著的提高索引性能。
The default value of this parameter is 10. If you have enough ram, set the value of this parameter as large as possible to decrease the indexing time dramatically.
一旦索引表再也无法装入内存，数据库的性能就会直线下降，所以应该尽量升级内存，以便存放那些表。
Database performance plummets once index tables don't fit in memory anymore, so scale up memory as far as possible to hold tables.
还请记住，AIX上大约有最大为250MB的私有虚拟内存用于LOAD中的索引键排序(这是内存瓶颈)。
Also keep in mind that on AIX, there is approximately a Max of 250mb of private virtual memory for index key sorting in LOAD (this is a memory bottleneck).
对索引所做的更改最初缓存在内存中，并周期性转储到索引目录。
The changes made to the index are initially buffered in the memory and periodically flushed to the index directory.
HSQLDB将所有表和索引数据放在内存中，将所有发出的sql语句保存到一个名为database .script的文件中，该文件同时也充当着事务日志的角色。
HSQLDB keeps all table and index data in memory, saving all SQL statements issued into a file named database.script, which also ACTS as the transaction log.
当索引需要更多的内存，Database会创建另一个 16KB 的Chunk。
The Database creates further 16 KB Chunks as the index requires more memory.
“另一种定义是，如果一个数据库的索引即使是超级计算机或计算机集群的tb级物理内存都无法容纳，那么可以称之为超大数据库，”他说。
"Another definition would be a database whose index can no longer fit in physical memory-even the terabyte memory of a supercomputer or cluster of machines," he says.
当把内存块返回给空闲池时，像分配时一样计算bucket索引。
When a block of memory is returned to the free pool, the bucket index is calculated just like it is done with allocation.
实际上，对内存中的表进行表扫描要比通过索引搜索同一表快得多，尤其是在使用 Informix轻型扫描机制时。
Actually, a table scan of an in-memory table is much faster than searching the same table through an index, especially with the Informix light scan mechanism.
极快的Lucene内存索引。
IndexWriter公开了几个控制如何在内存中缓存索引并写入磁盘的字段。
IndexWriter exposes several fields that control how indices are buffered in the memory and written to disk.
Lucene将输入数据存储在名为逆序索引的数据结构中，该数据结构以索引文件集的形式存储在文件系统或内存中。
Lucene stores the input data in a data structure called an inverted index, which is stored on the file system or memory as a set of index files.
比如，添加的已索引Field越多，对内存的需求就越多、索引就越大、优化该索引所需的时间也越长。
For instance, the more indexed Fields added, the greater the memory requirements, the larger the index, and the longer it takes to optimize the index.
RAMDirectory—在内存中存储所有索引的实现。
RAMDirectory - An implementation that stores all the indices in the memory.
最常见的内存中数据库索引策略是T -树。
The most common in-memory database index strategy is called T-tree.
SQLFire提供了一个JDBC与ADO.NET接口，用于以纯s QL的方式查询数据库，但键与索引却是存放在内存中以提供高可伸缩性、可用性及更棒的性能。
NET interface for querying the datastore in a pure SQL manner, but the keys and indexes are stored in memory to provide high scalability, availability and better performance.
其关键技术在于索引查找和内存控制。
The index search and memory control were the key technology.
其关键技术在于索引查找和内存控制。
The index search and memory control were the key technology.
应用推荐