Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ArcGIS > Oracle

539040Jul 30 2008 — edited Aug 26 2008
I downloaded the US state borders from the US Census Bureau (1) and loaded the shapefile into Oracle 11.1. I ran sdo_migrate.to_current on the data and created a spatial index. I then tried to take a union of the entire dataset to create a US border like this:

select sdo_aggr_union(SDOAGGRTYPE(geom, 0.5)) from states

This operation completed in 25 min on a Core 2 Duo 2.4GHz laptop.

Next I loaded the same shapefile into ArcMap 9.2 and did the same union operation. This completed in less than a second. I then loaded the new shapefile into Oracle and had my result in a few minutes.

Why is Oracle 1000x slower than ArcMap at doing unions?

(1) http://www.census.gov/geo/cob/bdy/st/st00shp/st99_d00_shp.zip

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 23 2008
Added on Jul 30 2008
#database-key-features, #spatial
3 comments
3,621 views