-- creating spatial indexes
-- **NOTE** storage parameters should be added for large tables
-- if the tablespace is not locally managed.

drop index warehouses_sidx;
create index warehouses_sidx on warehouses(WH_GEO_LOCATION)
indextype is mdsys.spatial_index;


drop index customers_sidx;
create index customers_sidx on customers(CUST_GEO_LOCATION)
indextype is mdsys.spatial_index;