Q: How do I calculate the table and index size for a partitioned table (or any table for that matter)?
Q：如何计算已分区表（或者任何相关的表）的表大小和索引大小？
The index key size limit also applies to those constraints that are enforced through indexes.
索引键大小限制也应用于通过索引施加的那些约束。
Often, there is a natural limit to the size of equity portfolios: if they become too big they start to resemble expensive index funds.
往往对股权资产组合规模有个自然限制：如果资产规模过大，那就有点类似昂贵的指数型基金。
Inlining can reduce the size of the regions index dramatically since inlined documents do not require any regions index entries.
内联功能可以显著减小区域索引的大小，因为内联文档不需要任何区域索引条目。
The size of the physical address (the address used by the processor to index physical RAM) limits the amount of memory that can be addressed.
物理地址(处理器用于索引物理ram的地址)的大小限制了可以寻址的内存。
From the table space snapshot data, the used page objects can be used to tell the total size of the index, tables, and the total database size.
从表空间快照数据中可以看出，这些用过的页面对象可用于告知索引、表和数据库的总大小。
The costs used to find a leaf page depends on the size of the index, the filer of the query, and the uniqueness of the index.
用以读取叶子页面的成本取决于索引的大小、查询的筛选器以及索引的惟一性。
Spam control is pretty good, speed is pretty good, the size of the index is pretty good.
垃圾邮件的控制相当不错，速度相当不错，指数的大小非常好。
Q: Why is the size of a global index significantly larger than if the same index was local?
Q：为何全局索引的大小明显比相同的本地索引大？
It should be noted that the DB2 index key size limit is 1024 bytes, and the index key limit includes all overhead bytes.
应该注意，db2索引键的大小限制为1024字节，而且索引键限制包括占用的所有字节。
The population size was chosen to be 256, because that way it was easy to initialize every individual to a number equal to its index.
取大小为 256 的人群，原因是这样便于把个体都初始化成一个与其序号相等的数字。
Google would not comment on Cuil and would not disclose the size of its own index.
Google对Cuil不做任何评论对自己的索引的大小也只字不提。
If the data is stored sequentially, the time to find the item is proportional to the size of the list. For each element, a hash function calculates a number, which is used as an index into the table.
如果数据是序列存储的，从中查询一个项的时间取决于数据列的大小。
A hash index is often implemented using an array where each element in the array is a hash bucket with a fixed size, as is depicted in Figure 1.
hash索引常常使用一个数组来实现，数组中的每个元素是一个有固定大小的hashbucket，如图1所示。
Logical page size (for example, in the CREATE INDEX statement above, PAGESIZE was required).
逻辑页面尺寸(例如，在上面的CREATEindex语句中，需要PAGESIZE)。
Select the number of instances you want to create, the name (an index is added for each instance), the size, the key pair, etc.
选择想要创建的实例数、名称（为每个实例添加一个索引）、大小、密钥对等。
You can also easily create multiple volumes in a single request by providing a name (which is postfixed with an index), the location, the size, and the format.
您还可以通过提供名称(有后缀索引)、位置、大小和格式在一个请求中轻松创建多个存储卷。
Slicing works by stating the starting index, the ending index, and an optional step size, all separated by semicolons.
分段的工作方式是声明开始索引、结束索引和一个可选的步骤大小，全部都用分号分隔。
Some of the typical string-related checks include verifying that an empty string has 0 size and accessing out of index from the string results in an error message/exception.
与字符串相关的典型检查包括检查空字符串的长度是否为 0以及访问范围超出索引是否导致错误消息/异常。
Use one buffer pool, but increase its size until the index hit ratio stops increasing.
使用一个缓冲池，但是增加其大小直至索引命中率停止增长。
The strategy of using byte index values in the place of tags reduces the size of restructured documents somewhat, but also limits the algorithm to handling DTDs with fewer than 254 distinct tags.
使用字节索引值来代替标记的策略在某种程度上减少了重新构造后的文档的大小，但也限制算法只能处理不同标记数少于254的DTD。
The advantage achieved is reduced index size which, in theory, provides faster retrieval rates for data.
这么做的好处是减小了索引的尺寸，从理论上来说，这会提升数据的检索速度。
But the size of each state's handout would be tied not to runaway medical inflation, but to the much more sedate general price index.
但各州发放补助的大小并不与失控的医疗通胀挂钩，而是与更加稳定的基本物价水平挂钩。
So far, the researchers apparently have created holograms only about the size of an index card.
至今，研究人员显然只制成了索引卡大小的全息图。
This process can take a long time based on the size of the index, the CPU, and the amount of memory available.
根据索引、CPU以及可用内存的大小，这个过程可能需要较长的一段时间。
Indexes won't help much when the size of your data is small or when the majority of queries issued against your database would generally not benefit from an index.
如果数据大小较小，或者索引对于数据库查询的性能改善帮助不大，则不适合使用函数索引。
The distance between the index finger and the thumb was estimated to be on average 69 per cent larger than the actual size of the participants’ hands.
关于食指与拇指之间的距离，估计值比参与者左手食指与拇指的实际距离平均要长69%。
Check your graphics software table of contents or index for resize, size, transform, reduce, or enlarge, all synonyms for the for the same thing.
查看你的图形软件包表上的内容或者索引上的重新调整，尺寸大小，改变，缩小，或者放大，所有的标志都指着同样的事。
Researchers from the University of Sydney, Australia, report that left atrial size increases with body mass index in children.
来自澳大利亚悉尼大学研究人员报告儿童的左心房大小随着体重指数的增加而增加。
Researchers from the University of Sydney, Australia, report that left atrial size increases with body mass index in children.
来自澳大利亚悉尼大学研究人员报告儿童的左心房大小随着体重指数的增加而增加。
应用推荐