另一个方法可能需要较多的操作,但是允许利用潜在的(“虚拟的”)索引查看访问计划。
Another option, which takes a little more effort, but allows viewing the access plan utilizing potential (" virtual ") indexes, is to use the following approach.
磁盘访问率和配置影响数据库、视图打开和集合导航(查看索引)的速度。
Disk access rates and configurations affect the speed of database and view opening and of opening and navigating a collection (view index).
为检查在查询时是否真正使用了一个空间网格索引,应该查看一下访问计划。
To check if a spatial grid index is actually exploited during query time, you should have a look at the access plan.
应用推荐