In theOracle spatial Partitioning application Research: partition and sub-table query performance comparison has been explained: by the county partition + Global Spatial index efficiency is better than by county partition + local spatial index, so in the experiment report, the combination of county partition + local spatial index is no longer considered, The experimental subjects of this experiment are as follows 3:
- by county partition + Global Spatial Index
- By city partition + local spatial index
- By province partition + local spatial index
First set of experiments:
The second set of experiments:
Conclusion:
- Highest efficiency by province partition + local spatial index
- Part_query algorithm Optimal
(not to be continued ...) )
Oracle Spatial Zoning Application study Three: efficiency comparison of different partition granularity in county and city