That is, DB2 scans every single leaf page.
也就是说,DB2扫描每一个单一的叶级页。
All paths from the root page to any leaf page traverse the same number of levels.
从根页面到任何叶页面的路径均穿过相同数量的层。
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.
用以读取叶子页面的成本取决于索引的大小、查询的筛选器以及索引的惟一性。
You can also make the leaf pages hidden from navigation by using cross-page wires to activate the pages and establish context.
通过使用跨页面连接激活页面并建立上下文,可以在导航时隐藏叶页面。
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。
Suddenly T-Bag spills some tea on the leaf of a page and boom - a clue comes out.
T - Bag一不小心洒了茶水在一页纸上,然后——新的线索就出现了。
As each leaf index row is passed to the index create component, it is included in a leaf index page in the buffer.
每个叶索引行在传递到索引创建组件时,均包含在缓冲区的叶索引页中。
The inner leaf is decorated with light blue silk, the front cover page including a realistic painting of the bronze mirror within and yellow slip inscriptions for the mirror and its contents.
内页糊天青色绫,封面内页为所储铜镜的写真画片,并有书写该镜器名及描述的黄签题记;
The leaf-level pages store the index keys and page pointers, plus a pointer to the row offset table on the data page.
并且聚集索引中数据页就是页级别索引页,综合上述两点,聚集索引占据空间更小。
For larger tables, the root page stores pointers to the intermediate level index pages or to leaf-level pages.
对于很小的表,只需一个根索引页即可。大表可能会有很多中间页。
For larger tables, the root page stores pointers to the intermediate level index pages or to leaf-level pages.
对于很小的表,只需一个根索引页即可。大表可能会有很多中间页。
应用推荐