If a table can either be placed into a smaller page size table space or fully utilize a larger page size, then the most frequent method of access determines which one is better.
如果可以将表放到具有较小页的表空间中,或者可以充分利用较大的页大小,那么最常用的访问方法将确定哪一个更好。
Diels is trying to cut down the size and says that a laser around the size of a small table is in the offing.
迪埃尔斯正试图缩小尺寸,他说一种小桌子大小的激光即将问世。
Now that fiscal policy is back on the table, economists are fighting over the size of the ripple effect.
现在的财政政策已经摆在那里了,经济学家正在为了抗击连锁效应而努力。
If you see a high purge count, increase the size of the ARP table.
如果您发现较高的清除计数,那么可以增大arp表的大小。
However, if you make it too large, you can waste valuable memory resources on your managed system due to the size of the page table created for the partition.
然而,如果将它设置的太大,则可能会由于为该分区创建的页表大小而浪费所管理系统上的宝贵内存资源。
Table and tablespace size limits in DB2 are on a per partition basis.
在DB 2中,表和表空间的大小限制是根据每个分区进行规定的。
Depending on the size of the table and network traffic, query performance could suffer.
取决于表的大小和网络的传输情况,查询性能可能会很糟糕。
The size of the table (number of entries per page) and data refresh rates can also be changed to meet the your needs.
还可以修改表的大小(每个页面上的条目数量)和数据刷新频率以满足自己的需要。
The size of other columns in the same table can further reduce this upper limit.
同一个表中其他列的大小可以进一步减少这个上限。
Another option is to decrease page table size by reducing page table entries.
另一种选择是通过减少页表中的条目来减少页表的大小。
Partitioning a database across multiple partitions lets you increase the maximum size of your table by a factor of the number of partitions in your environment.
跨多个分区划分数据库将允许您根据环境中分区数目的因数来增加表的最大大小。
Q: How do I calculate the table and index size for a partitioned table (or any table for that matter)?
Q:如何计算已分区表(或者任何相关的表)的表大小和索引大小?
Each join reduces the size of the fact table by one-tenth due to selectivity of the table filter on each dimension table.
由于每个维度表过滤的选择度,每次连接都会减少事实表大小的十分之一。
Yet, you may create more than one table per table space when the table size is small.
然而在表的尺寸较小时,您在每个表空间可以创建多个表。
DB2 V9 introduced a table partitioning feature that can increase the potential size of a single table, and significantly reduce the maintenance effort required to manage very large databases.
DB 2V 9引入了一个表分区特性,它能够增加一个表的可能大小,同时能够显著减少管理大型数据库所需要的维护。
Table 1 (in Figure 7) shows the size of the page table space allocated based on the maximum partition memory value.
表1(在图7中)显示了基于最大分区内存值来分配的页表空间大小。
The Numbers that appear in the three table nodes in the graph indicate the size of the table in terms of number of records.
在访问路径图中的三个表节点上显示的数字从记录的数量方面说明了表的大小。
This design is not desirable, and must be refined to ensure that the size of the archive table is kept under control.
这种设计并不可取,因而必须加以改进以确保控制好档案表的大小。
If you attempt to alter a table to use this lock size option, and it isn't an MDC table, you will receive an SQLSTATE 628n error.
如果您尝试修改一个表,以便使用这种锁粒度选项,而那个表又不是mdc表,那么您将收到一个SQLSTATE 628n错误。
Table size: Compression tends to work better for larger table Spaces.
表的长度:对于更大的表空间,压缩更为有效。
Characteristics (table space type, page size, extent size) of the table Spaces used by the source and target tables must match.
源表和目标表使用的表空间的特征(表空间类型、页面大小、范围大小)必须匹配。
Inlined XML data always resides in the same table space as the relational columns of the table and cannot be stored on a different page size or in a separate table space.
内联的XML数据始终和表的关系列位于同一个表空间中,并且不能存储到不同的页宽或单独的表空间。
As a result, the size of the page table is of significance.
因此,页表的大小就很重要。
The total size of all values stored in a row of a DB2 table is limited by the page size that is used for the table space.
db2表中一个行中存储的所有值的总大小不能超过表空间的页宽。
The size of the page table is inversely proportional to the page size, which implies that the smaller the page size, the larger the page table, and hence more overhead.
页表的大小与页面大小成反比,这意味着页面大小越小,页表就越大,开销也就越大。
The larger the page size of your table space the lower the number of potential splits per document.
表空间的页宽越大,每个文档划分成的子块数量就越小。
Therefore the size of the WIP_ARCHIVE table can be kept to a reasonably small size, depending on the frequency at which the transfer of data is performed.
因此根据该数据转移的执行频率,wip_archive表的大小可以保持得相当小。
Queues are limited in size, but can be combined with Table and Blob Storage.
队列的大小是有限制的,但是它可以与Table和Blob存储组合使用。
For example, DB2 UDB LUW allows a maximum size of 512 GB for a table per partition.
比如,DB 2UDBLUW在每个分区上允许表最大为512GB。
For example, DB2 UDB LUW allows a maximum size of 512 GB for a table per partition.
比如,DB 2UDBLUW在每个分区上允许表最大为512GB。
应用推荐