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

Space curve based partitioning

In this section, we will describe an example to show how to use a space curve value as the partition key to achieve partitioning that is similar to X and Y-based partitioning. This approach has some advantages and disadvantages when compared to multi-key range-based partitioning. We can use a single partition key instead of the multi-column partition key. If a new partition is to be added by splitting any of the existing partitions, multi-key partitions are harder to manage if only one partition needs to be split based on the first value of the partition key. On the other hand, the multi-key partitioning provides an easy-to-use method for coming up with initial partitions that have the same number of rows in each ...

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