DB2 row compression was designed to reduce disk storage space requirements of database objects.
DB 2行压缩被设计用来减少数据库对象的磁盘存储空间需求。
This means that if the row size is over (about) 4k, only one row will fit on a page and (about) 4k of space is wasted on the page.
这意味着如果行大小超过(或者接近)4k时,一页只适合一行,这样该页大约有4 k的空间就浪费了。
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.
注意,删除活动或更新活动可以实现空间重用,这将改变行大小,并且在表重组之后才会发生。
For example, if you have a table space with a page size of 4 KB (4096), then the maximum length of a row is restricted to 4005 bytes (see the Resources section for more information on SQL limits).
例如,如果有一个页宽为4KB(4096)的表空间,那么一行的最大大小不能超过4005字节(请参阅参考资料一节,了解关于SQL限制的更多信息)。
Shortages in the lock maintenance space can lead to so-called lock escalations, in which row locks are escalated to undesirable table locks, which can even lead to deadlock situations.
锁维护空间不足可能会导致所谓的“锁提升”,其中,行锁被提升为不必要的表锁,这甚至可能会导致死锁情况。
Small XML documents that occupy less than 32kb of storage space can be inlined with any relational data present in the same row, and the entire row can be compressed.
占用的存储空间少于32kb的小型XML文档可以与关系数据一起内联存储在同一行中,可以对整行进行压缩。
A row or two of pegs makes use of wall space and frees up the entryway floor and closet.
一两排挂钩可以利用墙上空间,空出入口的地板和壁橱。
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表中一个行中存储的所有值的总大小不能超过表空间的页宽。
Recapture lost space due to row deletions.
回收由于行删除而丢失的空间。
You can use the SQL statement in Listing 1 below to determine whether setting the table attribute value compression will save space for a table concerned by using the row format of value compression.
可以使用下面清单1中的sql语句来确定,通过设置表属性VALUECOMPRESSION,是否可以因使用值压缩的行格式而节省表的空间。
Think of the access log of a web server where the IP address and browser agent are repeated in every row, taking up space but simplifying bulk processing.
想一想web服务器的访问日志,其中每一行都重复了IP地址和浏览器代理,这虽然占用了空间但却简化了批量处理。
Myisampack.exe Compresses myisam table use VALUE COMPRESSION in create table statement to use the space saving row format at the column or table level to reduce space required for a table.
exe压缩myisam表在创建表的语句中使用VALUECOMPRESSION,可以在列或表级别上使用节省空间的行格式来减少空间占用。
The default mode is for DB2 to search the free space Control Records (FSCR's) interspersed in a table's pages to find a page that has enough free space to hold the new row.
缺省模式是,DB 2搜索散布在表的各页上的自由空间控制记录(Free Space Control Records,FSCR),以找到有足够自由空间存放新行的页。
Both of these will cut off a row of widget space, but make the slider easier to use.
二者都会减少一排小工具空间,但让滑条更易用。
The goal was to press the space bar on a keyboard whenever they saw a picture twice in a row.
他们要完成的任务就是在看见某张图片第二次出现时按下空格键。
China has chalked up 48 successful space launches in a row since October 1996.
自1996年10月以来,我国已连续第48次取得太空发射成功。
Now, it's great that so much space is saved by showing only one repeat row at a time, but a user of this form may want to manipulate the data for a row other than the one initially shown.
现在,由于一次只显示一个repeat行,因而节约了大量空间,这很棒,但是,除了最初显示的行的数据,此表单用户可能还想要操作其余行的数据。
There does seem to be a tiny bit of unused space below the bottom row of keys but this seems to be necessary to permit the slider to merge into the main body.
底部按键下方有一段无用区域,这是将滑动块融入机身所必需的。
Softbank's flagship stores look almost comical now, with rows and rows of iPhones broken only by the occasional row of iPads, in a space that used to have a wide array of handsets.
软银的旗舰店如今看上去简直是滑稽,一排排全是iPhone,只是偶然在中间穿插摆放一两排的iPad,以前这里的手机可是种类繁多啊”。
“A front-row seat of space, ” Truglia said. “I think that will appeal to a certain sector of society, people that want to adventure and live on the edge.”
“一张观赏太空的前排座票,”特鲁格利亚说,“我想对社会上的一部分人是有足够的吸引力的,这些人的特点就是希望生活中充满挑战和冒险。”
This leaves sufficient space for at least one row of the maximum size that the index can have, based on the set of keys on the intermediate pages.
这样将至少为索引可以基于中间页中的键集拥有的最大大小的一行留出足够的空间。
This paper give an expositior of simple way to display that the dimension of row space of matrix equals to the dimension of column space and some shortcuts to solve the problems concerned.
本文给出了证明矩阵行空间维数等于列空间维数的另一种较简单的证法,以及解决几个相关问题的捷径。
It angular form is mirrored by a row of cupboards that creates storage space for the master bedroom.
一排橱柜有角度的形式,为主卧室创建储存空间。
There should be a space at the end of each row so that people in wheelchairs can sit beside their friends.
在每一排的后面都应该有一定的空间,让坐轮椅的人可以坐在他们朋友的旁边。
A row of skylights extends across this extra space, joining up with a wall of storage built from oak.
一排天窗延伸至附加的空间上,与用橡木做的存贮墙壁连接。
Therefore, in the heart of the urban block, overlooked by the plant row, the play areas resemble to a big roofless space, sheltering children's games.
因此,城市街区中心的游乐区被植物俯瞰,像没有屋顶的大型空间,保护儿童嬉戏。
Just still having some unable to decide bodyguards finally to descend under the reprimanding angrily to of space orchid hero is cruel, directly came up a control to live to add row necessarily.
方才还有些迟疑的侍卫终于在格兰杰的呵斥下下了狠心,直接上来控制住了加列必。
After the space has been allocated in the row directory of a data block's overhead, this space is not reclaimed when the row is deleted.
一旦一个数据块的开销中的行目录已经被分配了空间,那么这个空间不会在这行记录删除的时候被回收利用。
This function checks to see if there is enough space on the current page to print another row, and ejects the page if not.
这个函数检查看当前页是否有足够的空间来打印另外一行,如果没有,则离开当前页。
This function checks to see if there is enough space on the current page to print another row, and ejects the page if not.
这个函数检查看当前页是否有足够的空间来打印另外一行,如果没有,则离开当前页。
应用推荐