5 Indexing and Querying Spatial Data
After you have loaded spatial data, you should create a spatial index on it to enable efficient query performance using the data.
Note:
Spatial supports the use of sharded database technology. For information about indexing and querying data in a sharded database environment, see Sharded Database Support by Oracle Spatial.
- Creating a Spatial Index
Once data has been loaded into the spatial tables through either bulk or transactional loading, a spatial index (R-tree index or CBTREE index (for point data), cross-schema spatial index, or partitioned spatial index) should be created on each geometry column in the tables for the most efficient access to the data. - Querying Spatial Data
The structures of a spatial layer are used to resolve spatial queries and spatial joins.
Related Topics
Parent topic: Conceptual and Usage Information