Home | Previous Page | Next Page   Managing Databases That Use the R-Tree Secondary Access Method > Checking R-Tree Indexes with the oncheck Utility >

Checking Pages with the -ci and -cI Options

The -ci and -cI options tell the oncheck utility to walk through the R-tree structure, checking that the bounding box in the parent page matches the master bounding box on the child page for all nonleaf pages. In addition, the utility checks that the master bounding box on each page contains all of the bounding boxes for items on the page. Finally, the utility checks that the right-pointing links point to a valid R-tree page.

The following example shows how to use the -ci and -cI options:

oncheck -cI rtree_db:polygons

In the example, the oncheck utility is checking any R-tree indexes that exist on the polygons table in the rtree_db database.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]