indexing in oracle spatial sdo_geometry

VadivelanPalanichamy — Mon, 23 Apr 2012 17:08:11 GMT

Hi,

I have tried uploading the file gdb using arccatalog/arcsde 9.3 into oracle spatial as sdo_geometry datatype.

I have removed the spatial index in the fgdb and then uploaded, but after uploading i have seen the spatial index generated in oracle spatial table.

I would like to know, whether this new spatial index is generated by oracle spatial or arcsde ?

Re: indexing in oracle spatial sdo_geometry

VinceAngelo — Mon, 23 Apr 2012 20:03:58 GMT

The answer is "Neither" or "Both".

The SDO_GEOMETRY type is used by both Oracle Spatial and Esri ArcGIS, but it is provided
by Intermedia, which is part of the base Oracle install capability. I never install Spatial, and
I always have SDO_GEOMETRY available.

ArcSDE is the Esri technology which integrates Esri's client applications with major databases
to provide versioned geodatabase and ST_GEOMETRY capability. It does nothing of its own
volition, though clients like Catalog are fond of generating indexes when data tables are
created and populated through ArcObjects (after all, they can't be effectively queried without.
an index). If you don't wish a spatial index to be constructed, you may need to code your
own import tool (or to drop it before performing further processing).

There is no relationship whatsoever between the index on file geodatabases and the index
Oracle provides for SDO_GEOMETRY columns.

- V

topic Re: indexing in oracle spatial sdo_geometry in Data Management Questions

indexing in oracle spatial sdo_geometry

Re: indexing in oracle spatial sdo_geometry