So we create a spatial grid index that will be used at query time.
所以我们创建一个空间网格索引,这个索引将在查询时用到。
Create a grid index on the spatial column.
在空间列上创建一个网格索引。
If all conditions are met, including the simple syntax rule, it is still not ensured that a spatial grid index is used to satisfy the query.
如果所有条件都符合,同时也符合简单的语法规则,那么还不能保证可以使用空间网格索引来满足查询。
To check if a spatial grid index is actually exploited during query time, you should have a look at the access plan.
为检查在查询时是否真正使用了一个空间网格索引,应该查看一下访问计划。
Now that the spatial table is populated, it is time to add a spatial index to support spatial queries; in DB2 that is a grid index.
既然已经填充了空间表,就应该添加空间索引来支持空间查询了;在DB 2中这是一个网格索引。
As was explained before, the DB2 optimizer is not fully aware of all the details of the spatial grid index.
前面我们解释过,DB 2优化器不完全知道空间网格索引的细节。
None of the other spatial functions can exploit a grid index.
其他任何空间函数都不能使用网格索引。
If you are familiar with spatial data and the grid index, the results are pretty much self-explanatory.
如果您熟悉空间数据和网格索引,那么结果就无需解释了。
Through the analyses of the grid index and the spatial object index, a structure of the spatial object boundary index based on wide grids is put forward.
在充分分析格网索引和空间对象范围索引的基础上,提出一种基于粗分格网的空间对象范围索引结构。
According to the characteristics of spatial index of grids and R-tree, a hybrid structure of spatial multilevel index is presented based on grid and R-tree.
结合网格索引和R树索引的特点,提出了一种基于网格与R树的多级混合索引。
According to the characteristics of spatial index of grids and R-tree, a hybrid structure of spatial multilevel index is presented based on grid and R-tree.
结合网格索引和R树索引的特点,提出了一种基于网格与R树的多级混合索引。
应用推荐