增加的表大小限制和容量。
Q:如何计算已分区表(或者任何相关的表)的表大小和索引大小?
Q: How do I calculate the table and index size for a partitioned table (or any table for that matter)?
自动表重组不会考虑那些表大小估计值大于大小条件的表。
Tables whose estimated size is greater than the size criteria are not considered by automatic table reorganization.
优化器使用表大小、索引可用性以及数据分布等信息来确定响应该查询的最佳路径。
The optimizer USES information such as table sizes, availability of indexes, and data distribution to figure out the optimal way to answer the query.
由于每个维度表过滤的选择度,每次连接都会减少事实表大小的十分之一。
Each join reduces the size of the fact table by one-tenth due to selectivity of the table filter on each dimension table.
然而,如果将它设置的太大,则可能会由于为该分区创建的页表大小而浪费所管理系统上的宝贵内存资源。
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.
非常深刻的前向后一小车床进行鞍几乎镗表大小的T型槽交叉幻灯片装有“桥梁支架”在前面。
Unusually deep front to back for a small lathe the saddle carried an almost boring-table sized T-slotted cross slide fitted with a "bridge bracket" at the front.
您可以随时更新时间的状态栏,然后单击确定,然后它将改变你的哈希表大小保存为32M到64m。
You can update seconds on status bar and click OK, then it will change to your choice. Hash table size: recommend to 32m to 64m.
如果索引的使用效率很低,或者根本就不能使用索引,则会减慢查询速度,而且随着服务器上的负载和表大小的增加,这个问题会变得更加显著。
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 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.
如果您发现较高的清除计数,那么可以增大arp表的大小。
If you see a high purge count, increase the size of the ARP 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.
另一种选择是通过减少页表中的条目来减少页表的大小。
Another option is to decrease page table size by reducing page table entries.
取决于表的大小和网络的传输情况,查询性能可能会很糟糕。
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.
在DB 2中,表和表空间的大小限制是根据每个分区进行规定的。
Table and tablespace size limits in DB2 are on a per partition basis.
这种设计并不可取,因而必须加以改进以确保控制好档案表的大小。
This design is not desirable, and must be refined to ensure that the size of the archive table is kept under control.
两个表均存储在页面大小为32 - KB的表空间中来最大化需要读取大量行的性能分析查询。
Both tables are stored in table Spaces with a 32-kb page size to maximize the performance analytical queries that read large Numbers of rows.
因此,页表的大小就很重要。
使用样式表动态更改屏幕的大小。
Using the style sheet to dynamically change the screen size.
注意:这个表的大小是由符号常量nr_syscalls定义的。
Note: the size of this table is defined by the symbolic constant NR_syscalls.
升级cell1的模式,包含升级表扩展大小和修改原表结构。
Upgrade schema for cell1, including upgrading tables extent sizes and modifying old table structures.
管理WIP历史表的大小
对于每个不同页大小的表空间,应该存在一个页大小相匹配的缓冲池。
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.
在数据仓库中,事实表或历史表的大小是摆在设计人员和管理员面前的一个挑战。
In data warehouses, the size of fact tables or history tables poses challenges to designers and administrators.
您可以选择通过不存储极其频繁重复的文本字段,而是将其一次性放置在一个子维度表中,节省该大小的表中的大量空间。
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.
这样可以确保能够在32K页面大小的表空间中创建任何行大小超过4 K字节的用户表。
This ensures that any user tables whose row size exceeds 4k bytes is successfully created into a 32k page size tablespace.
这样可以确保能够在32K页面大小的表空间中创建任何行大小超过4 K字节的用户表。
This ensures that any user tables whose row size exceeds 4k bytes is successfully created into a 32k page size tablespace.
应用推荐