Check pages with the -pl and -pL options
The -pl and -pL options display similar information about the root and branch pages as the -pk and -pK options. In addition, the -pl and -pL options also display detailed information about the leaf pages in an R-tree index followed by information about the data objects on the leaf page.
The -pl and -pL options
of the oncheck utility display the same information
listed in Check pages with the -pk and -pK options about
the root, branch, and leaf pages. In addition, for each data object
on a leaf page, the following information is displayed:
- size
- The size of the data object in bytes
- rowid
- The row ID of the data object in the indexed table
- The bounding box of the data object
The following example shows how to use the -pL option:
oncheck -pL rtree_db:polygonsThe following example shows the type of output about leaf
pages that oncheck -pL displays:
Node: Level 2, Pagenum 143, Usage 44.3%, No. of Children 5, right -1
Data record on page 143: size 136, rowid 1048992/30467
X(0.893479,1) Y(-0.176591,0.267366) Z(-0.0306181,0.388314) A(any) T(any)
Data record on page 143: size 136, rowid 1048992/16386
X(0.916716,1) Y(-0.399292,0.126833) Z(0.00581815,0.025057) A(any) T(any)The example displays only two of the five children of the leaf page; the output for the remaining children is similar.