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

Parallel queries and partitioning

One of the benefits of partitioning is the ability to parallelize spatial queries. If the query window spans multiple partitions (as is likely to happen with DATE based partitioning), then each partition can be queried in parallel. But the default behavior of partitioned spatial queries is not suitable for queries that span a large number of partitions on systems that have a large number of processors available for the queries. When a spatial query is issued against a partitioned spatial table and no partition key is used in the Where clause, then the spatial internally rewrites the query so that only those partitions that can potentially interact with the given window geometry are used. This is done by doing ...

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