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.
现在的财政政策已经摆在那里了,经济学家正在为了抗击连锁效应而努力。
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中,表和表空间的大小限制是根据每个分区进行规定的。
It then produces a table for each collection sorted by size of collection, with the most frequent size first.
然后它会为每个集合生成一个表,并按照集合大小排序,其中最频繁使用的大小排在前面。
The size of the table (number of entries per page) and data refresh rates can also be changed to meet the your needs.
还可以修改表的大小(每个页面上的条目数量)和数据刷新频率以满足自己的需要。
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:如何计算已分区表(或者任何相关的表)的表大小和索引大小?
You can expect to save quite a bit of space in a table of that size by not storing the very frequently repeated text fields, but rather putting them once in a subdimension table.
您可以选择通过不存储极其频繁重复的文本字段,而是将其一次性放置在一个子维度表中,节省该大小的表中的大量空间。
Each join reduces the size of the fact table by one-tenth due to selectivity of the table filter on each dimension table.
由于每个维度表过滤的选择度,每次连接都会减少事实表大小的十分之一。
For example, a table space with 32kb page size can now store 64tb. Previously it could store only 16tb.
例如,页面大小为32kb的表空间现在可以存储64tb,而在此之前只能存储16tb。
Note that reuse of space made available by delete activity or update activity, which changes row size, does not occur until the table is reorganized.
注意,删除活动或更新活动可以实现空间重用,这将改变行大小,并且在表重组之后才会发生。
Table 2 shows the size of each member of the structure and the structure size itself on 32-bit and 64-bit systems.
表2给出了这个结构中每个成员的大小,以及这个结构在32位系统和64位系统上的大小。
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中)显示了基于最大分区内存值来分配的页表空间大小。
So let's look at the second example, all right, I keep doing that — this piece of code from here to here gives me a way of now creating a hash table of size 256.
所以让我们来看一下第二个例子,好的,我继续做那件事,这段代码中从这里到这里,是创建一个大小为256的哈希表。
The Numbers that appear in the three table nodes in the graph indicate the size of the table in terms of number of records.
在访问路径图中的三个表节点上显示的数字从记录的数量方面说明了表的大小。
Tables whose estimated size is greater than the size criteria are not considered by automatic table reorganization.
自动表重组不会考虑那些表大小估计值大于大小条件的表。
For each logging token read from the Shared memory or configuration file on its first invocation, OPEN_LOG builds a hash key using the name of the token and the size of the hash table.
对于每个从共享内存或初次调用使用的配置文件中读取的日志标记,OPEN_LOG都会使用标记名和散列表的大小来生成一个散列值。
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数据始终和表的关系列位于同一个表空间中,并且不能存储到不同的页宽或单独的表空间。
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存储组合使用。
应用推荐