Home
|
Previous Page
|
Next Page
Managing Databases That Use the R-Tree Secondary Access Method
In This Chapter
Performance Tips
Updating Statistics
Deletions
Effectiveness of Bounding Box Representation
Clustering Spatial Data on the Disk
Returning the Coordinates of the Root Bounding Box
Syntax
Example
Estimating the Size of an R-Tree Index
Calculating Index Size Based on Number of Rows
Using the oncheck Utility to Calculate Index Size
R-Tree Index and Logging
Description of the R-Tree-Specific Logical-Log Records
Logical-Log Records of Insertions of Items into a Leaf Page
Logical-Log Records of Deletions of Items from a Leaf Page
Using the onlog Utility to View R-Tree Logical-Log Records
System Catalogs
sysams
sysopclasses
sysindices
Checking R-Tree Indexes with the oncheck Utility
Checking Pages with the -ci and -cI Options
Checking Pages with the -pT Option
Checking Pages with the -pk and -pK Options
Checking Pages with the -pl and -pL Options
Other Options with -u
Home
| [
Top of Page
|
Previous Page
|
Next Page
|
Contents
|
Index
]