O'Reilly logo

Applying and Extending Oracle Spatial by Siva Ravada, Simon Gerard Greener

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Spatial partitioning of tables

Tables with geometry can also be partitioned with a spatial key that is, the partitioning is done such that the rows that are close to each other in space will likely be placed in the same partition. There are several methods for using the spatial key to partition the data, and these methods vary depending on the type (point, line, or polygon) of spatial data. One of the main advantages of using a spatial partitioning key is the spatial pruning that comes into play during the query execution. In this section, we explain this concept and show how spatial pruning can help reduce query runtimes. First we look at tables with point data and explain the spatial partitioning of tables.

Single column key

Range-based partitioning ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required