Use Accurate Spatial Extents

The spatial extents of data read from Oracle are read (if they exist) from the Oracle spatial metadata table (USER_SDO_GEOM_METADATA).

The more accurate these extents are, the better the performance of spatial searches. It will still find and process data regardless of these extents (although if they are orders of magnitude wrong the Build Topology task might complain) but it will improve performance if they are roughly right. This will improve all conditions or operations which use the geometry as the first comparison, as well as the Build Topology task.

To see the current setting for the spatial extents, you can view the geometry attributes (see Viewing Geometry Attributes).