选择要调整的表,然后拖动该表的大小调整控点。
Select the table that you want to resize and then drag its resize handles.
这种设计并不可取,因而必须加以改进以确保控制好档案表的大小。
This design is not desirable, and must be refined to ensure that the size of the archive table is kept under control.
这些临时表的大小约为500MB每个标准,我用它。
The size of these temp tables is around 500 MB each criteria , I use it.
在访问路径图中的三个表节点上显示的数字从记录的数量方面说明了表的大小。
The Numbers that appear in the three table nodes in the graph indicate the size of the table in terms of number of records.
在数据仓库中,事实表或历史表的大小是摆在设计人员和管理员面前的一个挑战。
In data warehouses, the size of fact tables or history tables poses challenges to designers and administrators.
还可以修改表的大小(每个页面上的条目数量)和数据刷新频率以满足自己的需要。
The size of the table (number of entries per page) and data refresh rates can also be changed to meet the your needs.
一个问题是,这种表的大小要比普通表增长得快,可能会导致一些严重的性能问题。
For one, they grow much faster than normal tables and thus can cause some serious performance issues.
页表的大小与页面大小成反比,这意味着页面大小越小,页表就越大,开销也就越大。
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.
因此根据该数据转移的执行频率,wip_archive表的大小可以保持得相当小。
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.
GPT默认支持128个分区,当然您也可以更改分区表的大小,如果您的分区软件支持这种更改的话。
By default, 128 partitions are supported, although you can change the partition table size if the partitioning software supports such changes.
为函数添加此附加功能的方法非常简单:提供名为nrows和ncols的两个输入参数,允许在调用函数时更改乘法表的大小。
This additional power was simple to include in the function: You provide input parameters named nrows and ncols that allow the size of The Times table to be changed when the function is invoked.
你会发现,使用任何现有的简单“噪音表”,被判定为发出同样大小噪音的车辆,在表上可能显示出相当大的差异。
You find that with any existing simple "noise-meter", vehicles which are judged to be equally noisy may show considerable difference on the meter.
如果有一些具有不同页大小的表空间,那么每种页大小必须至少有一个缓冲池。
If there are table Spaces with different page sizes, there must be at least one buffer pool per page size.
不能将行分割到不同的页,因此具有长行的表需要有合适的页大小。
Rows cannot be split between pages, so tables with long rows require the appropriate page size.
没有必要拥有多个具有相同页大小的临时表空间,通常只需一个具有最大页大小的临时表空间就够了。
There is no reason to have more than one temporary table space of the same page size, and usually one with the largest page size is sufficient.
让我们来看一个表容器的实现,在这个表容器中,行和列的像素大小可以通过指定的权重进行扩展。
Let's look at an implementation of a table-container in which the pixel size of its rows and columns can expand via assigned weights.
如果索引的使用效率很低,或者根本就不能使用索引,则会减慢查询速度,而且随着服务器上的负载和表大小的增加,这个问题会变得更加显著。
Inefficient use of indexes, or not being able to use indexes at all, slows the queries, and this issue becomes more pronounced as the load on the server and the size of the tables increases.
您可以选择通过不存储极其频繁重复的文本字段,而是将其一次性放置在一个子维度表中,节省该大小的表中的大量空间。
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 a database that has table Spaces of more than one page size, additional buffer pools with matching page sizes need to be created.
Q:如何计算已分区表(或者任何相关的表)的表大小和索引大小?
Q: How do I calculate the table and index size for a partitioned table (or any table for that matter)?
这样可以确保能够在32K页面大小的表空间中创建任何行大小超过4 K字节的用户表。
This ensures that any user tables whose row size exceeds 4k bytes is successfully created into a 32k page size tablespace.
然而,如果将它设置的太大,则可能会由于为该分区创建的页表大小而浪费所管理系统上的宝贵内存资源。
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.
取决于您的数据库,您可能想要不同的页面大小,它与您的源表页面大小一致。
Depending on your database you may want to have a different page size that matches the page size of your base source tables.
用DB 2创建的默认数据库拥有一个4K页面大小的表空间。
A default database created by DB2 has a tablespace with a 4k page size.
在DB 2中,表和表空间的大小限制是根据每个分区进行规定的。
Table and tablespace size limits in DB2 are on a per partition basis.
您可以基于所使用的应用程序类型为不同的表空间选择不同的页面大小。
You can choose different page sizes for the different tablespaces based on the type of the application that is used.
如果创建表的表空间的页面大小不合适,或者应该用另一个缓冲区池访问表,就可能需要执行这种数据转移。
This may become necessary if the table was created in a tablespace with an inadequate page size or when a separate bufferpool should be used for accessing the table.
自动表重组不会考虑那些表大小估计值大于大小条件的表。
Tables whose estimated size is greater than the size criteria are not considered by automatic table reorganization.
自动表重组不会考虑那些表大小估计值大于大小条件的表。
Tables whose estimated size is greater than the size criteria are not considered by automatic table reorganization.
应用推荐