This requires the appropriate index pages to be in the buffer pool.
这要求在缓冲池中存在适当的索引页。
If this is the case, a larger buffer pool is the best solution, but adding more free space to index pages may also help.
如果的确是上述情况,那么使用更大的缓冲池是最好的解决办法,但是为索引页增加更多的自由空间也有所帮助。
This calculation takes into account all of the pages (index and data) that are cached by the buffer pool.
这个计算考虑了缓冲池高速缓存的所有页(索引和数据)。
The hit ratios for data and index pages reflect the number of times a page request was handled by the buffer pool directly without requiring disk I/O.
数据和索引页面的击中率反映了缓冲池在不需要磁盘I/O的情况下直接处理一个页面请求的时间量。
Thus, provide sufficient buffer pool space to support index reads.
因此,应提供足够的缓冲池空间来支持索引读操作。
If necessary, you can separate data and index into two different buffer pools to help ensure a good index buffer pool hit ratio.
如果必要,可以将数据和索引分隔到两个不同的缓冲池中,以帮助确保一个良好的索引缓冲池命中率。
After being read in from DASD, the data and index pages go into these slots and remain there until the DB2 buffer manager determines that those slots should be used for some other data.
数据和索引页被从DASD中读出之后,便进入这些插槽,并留在其中,直到DB 2缓冲区管理器确定那些插槽要用于其他数据。
A desirable goal for your buffer pool hit ratio is 80% or higher for data, and 90% or higher for index.
您的缓冲池命中率的理想目标是数据80%或更高,索引90%或更高。
Buffer pool index writes is much greater than Asynchronous pool index page writes.
缓冲池索引写远远大于异步池索引页写。
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数据库管理器在它读取或写入磁盘介质时将它分配给缓存表和索引数据。
DB2 USES buffer pools to cache the table and index data as they are being read or written to the hard disk drive.
当从硬盘驱动器读写表和索引数据时,DB 2使用缓冲池来缓存它们。
Buffer pool index writes is approximately equal to Asynchronous pool index page writes.
缓冲池索引写约等于异步池索引页写。
Typically, in a MDM Server implementation, if you start with one big buffer pool for both data and index you should be fine.
通常,在一个MDMServer实现中,如果您一开始就对数据和索引使用一个大缓冲池,那么应该不会出现问题。
The key buffer stores index blocks for MyISAM tables.
关键字缓冲区保存了myisam表的索引块。
Dbrun.snap - This script provides the hit ratio for the data and index pages of every buffer pool.
perl buffhitratio . pl dbrun. snap——该脚本提供了每个缓冲池的数据和索引页命中率。
After the fortune is written to the user buffer, I increment the next_fortune index by the length of the last fortune written.
在将这个fortune写入用户缓冲区之后,在next _ fortune索引上增加刚才写入的fortune的长度。
You can help speed up index maintenance by using a large buffer pool for the index tablespace, and, if possible, ordering the inserts so that the key values are ordered, not random.
如果为索引表空间使用较大的缓冲池,并且尽可能地将不同 insert排序,以便键值是排好序的,而不是随机的,就可以帮助加快索引维护。
Buffer pool index physical reads (defined in units of tablespace page size).
缓冲池索引物理读数(以表空间页宽为单位定义)。
Index buffer read: Number of buffer reads for index pages.
Index BufferRead:索引页面的缓冲区读数量。
Use one buffer pool, but increase its size until the index hit ratio stops increasing.
使用一个缓冲池,但是增加其大小直至索引命中率停止增长。
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.
缓冲池是内存中的一块存储区域,用于临时读入和更改数据库页(包含表行或索引项)。
Therefore, you have to convert the mask into a single index which can then be used to specify the buffer you are processing, and you have to do it without any branching.
因此,必须将掩码转换为一个索引(可以使用这个索引指定要处理的缓冲区),而且进行转换时不用任何分支。
The index position of the character in the input buffer.
该字符在输入缓冲区中的索引位置。
The index position of the surrogate pair in the input buffer.
该代理项对在输入缓冲区中的索引位置。
The index of the next character to read from the input stream buffer.
要从输入流缓冲读取的下一个字符的下标。
The value for "Rows read" is the lowest with parameter markers, but this is not really important, as the "Buffer pool index logical reads" go up in this case.
在有参数标记时的 “Rowsread”值最小,但实际上这并不重要,因为此时 “Bufferpoolindexlogicalreads” 值较高。
As each leaf index row is passed to the index create component, it is included in a leaf index page in the buffer.
每个叶索引行在传递到索引创建组件时,均包含在缓冲区的叶索引页中。
It represents terrain blocks detail levels by using an index buffer sequence, which resides in video memeory.
层次索引模板通过一组常驻显存的索引缓存序列,隐式地表示地形块细节层次。
For the reason of the no order of space data, the algorithm based on join index have to improve for it. The key problem of optimal page-access sequence with a fixed Buffer has been analyzed.
空间数据的无序性,使得应用在其上的利用连接索引的算法需要进一步的改进,为此分析了其中关键的最佳页访问次序问题。
This warning indicates that the writable extent of the specified buffer might be smaller than the index used to write to it.
此警告意味着指定缓冲区的可写范围可能小于用于写入它的索引。
应用推荐