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!

partitioning table by SDO_GEOMETRY column

571669Aug 14 2009 — edited Aug 17 2009

Hey Oracle users,
I have a question.. I've got 2 spatial datasets, 1 is a road network with >250 million rows (gtype 2002) and the other is a point table with ~99 million rows (gtype 2001). My spatial query gets all the roads with in 20 meters of a point. It works fine, but it takes a couple days to complete, so was reading up on partitioning the SDO_GEOM column to hopefully improve my performance. Can't find alot of documentation online about exactly how you partition a geometry column though. I did read oracle spatial only allows ranged partitions, so I guess my question is how exactly would you define the ranges for a geometry column?
I appreciate any direction and or help any of you can provide.
Thanks!
Eric

Edited by: ebrose on Aug 14, 2009 11:14 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 14 2009

Added on Aug 14 2009

#database-key-features, #spatial

8 comments

2,941 views