管理WIP历史表的大小
因此，页表的大小就很重要。
为什么切换到存储引擎增加表的大小？
Why does switching to the MEMORY engine increases the table size?
选择要调整的表，然后拖动该表的大小调整控点。
Select the table that you want to resize and then drag its resize handles.
另一种选择是通过减少页表中的条目来减少页表的大小。
Another option is to decrease page table size by reducing page table entries.
这种设计并不可取，因而必须加以改进以确保控制好档案表的大小。
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.
如果您发现较高的清除计数，那么可以增大arp表的大小。
If you see a high purge count, increase the size of the ARP table.
取决于表的大小和网络的传输情况，查询性能可能会很糟糕。
Depending on the size of the table and network traffic, query performance could suffer.
注意：这个表的大小是由符号常量nr_syscalls定义的。
Note: the size of this table is defined by the symbolic constant NR_syscalls.
在访问路径图中的三个表节点上显示的数字从记录的数量方面说明了表的大小。
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.
使用样式表动态更改屏幕的大小。
Using the style sheet to dynamically change the screen size.
不能将行分割到不同的页，因此具有长行的表需要有合适的页大小。
Rows cannot be split between pages, so tables with long rows require the appropriate page size.
对于每个不同页大小的表空间，应该存在一个页大小相匹配的缓冲池。
For every different page size tablespace, there should be a matching page size buffer pool.
没有必要拥有多个具有相同页大小的临时表空间，通常只需一个具有最大页大小的临时表空间就够了。
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.
如果索引的使用效率很低，或者根本就不能使用索引，则会减慢查询速度，而且随着服务器上的负载和表大小的增加，这个问题会变得更加显著。
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.
由于每个维度表过滤的选择度，每次连接都会减少事实表大小的十分之一。
Each join reduces the size of the fact table by one-tenth due to selectivity of the table filter on each dimension table.
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.
取决于您的数据库，您可能想要不同的页面大小，它与您的源表页面大小一致。
Depending on your database you may want to have a different page size that matches the page size of your base source tables.
取决于您的数据库，您可能想要不同的页面大小，它与您的源表页面大小一致。
Depending on your database you may want to have a different page size that matches the page size of your base source tables.
应用推荐