Creating a spatial index in Oracle

Oracle spatial can easily store spatial data, and large amounts of spatial data must be queried using spatial indexes. Creating a spatial index in Oracle requires that metadata be established before the index can be created. To create the code for the metadata:

1 Insert  intoUser_sdo_geom_metadata (Table_name,column_name, Diminfo, SRID)2 Values(3 'China_track',4 'track_mbr',5 Mdsys. Sdo_dim_array (6Mdsys. Sdo_dim_element ('X',- the, the,0.005),7Mdsys. Sdo_dim_element ('Y',- -, -,0.005)8 ),9 8307Ten);

Index inserts are made after the metadata is created (the default is R-Tree index):

Create Index  on   is Mdsys. Spatial_index;

It is important to note that the Srid developed in the metadata must be the same as in the original layer, otherwise the index cannot be inserted.

Creating a spatial index in Oracle