CREATE INDEX "MYSCHEMA"."STREETS_SX" ON "MYSCHEMA"."STREETS" ("GEOLOC")
INDEXTYPE IS "MDSYS"."SPATIAL_INDEX"  PARAMETERS ('SDO_LEVEL=11 SDO_NUMTILES = 4 sdo_commit_interval=1000');

CREATE INDEX streets_sx
ON myschema.streets
USING gist
(geoloc);