FREEPAGE may be another alternative to consider in this situation.
在此情况下,另一种可以考虑的方案是使用FREEPAGE。
For example, if you specify FREEPAGE 5, DB2 will allocate a page of free space after filling five pages with data.
例如,如果指定了FREEPAGE5,那么DB2将在用数据填充了5个页之后分配一页的空余空间。
FREEPAGE indicates to DB2 how often to leave a full page of free space when either loading or reorganizing the data.
FREEPAGE告诉DB 2在装载或重组数据时,应该过多久就分配一整页的空余空间。
FREEPAGE should be used if your table rows are larger than half a page, since you cannot INSERT a second row on a page in such circumstances.
如果表行大于页宽的一半,则应该使用FREEPAGE,因为在那样的环境下不能在一页上再INSERT一行。
You can also specify the FREEPAGE, PCTFREE, and CLUSTERRATIO values to be assumed for new indexes, and whether or not index leaf page size can exceed 4 KB.
您还可以指定REEPAGE、PCTFREE和clusterratio值用于新索引,而无论索引页能否超过4KB。
You can also specify the FREEPAGE, PCTFREE, and CLUSTERRATIO values to be assumed for new indexes, and whether or not index leaf page size can exceed 4 KB.
您还可以指定REEPAGE、PCTFREE和clusterratio值用于新索引,而无论索引页能否超过4KB。
应用推荐