Oracle Spatial Example: Warehouses and Branches, index statements

spatial_warehouse_branches_index_example.sql

INSERT INTO USER_SDO_GEOM_METADATA VALUES ('WAREHOUSES', 'GEOMETRY',
   SDO_DIM_ARRAY(
       SDO_DIM_ELEMENT('x', -180, 180, 0.05), 
       SDO_DIM_ELEMENT('y', -90, 90, 0.05)
   ),
   4326 -- Code for Latitude/Longitude coordinate
);

INSERT INTO USER_SDO_GEOM_METADATA VALUES ('BRANCHES', 'GEOMETRY',
   SDO_DIM_ARRAY(
       SDO_DIM_ELEMENT('x', -180, 180, 0.05),
       SDO_DIM_ELEMENT('y', -90, 90, 0.05)
   ),
   4326 -- Code for Latitude/Longitude coordinate
);

CREATE INDEX WAREHOUSES_SIDX ON WAREHOUSES (GEOMETRY) INDEXTYPE IS MDSYS.SPATIAL_INDEX;
CREATE INDEX BRANCHES_SIDX ON BRANCHES (GEOMETRY) INDEXTYPE IS MDSYS.SPATIAL_INDEX;