R-tree indexes and null values

The R-tree secondary access method uses bounding boxes of data objects to calculate how to insert the object into an R-tree index and how to subsequently search for the object. An R-tree index, however, cannot create a bounding box for a null value. For this reason, an R-tree index treats null values differently from non-null values.