在SQL Server 2000中查询R树 [英] query for R Tree in sql server 2000

问题描述

任何人都可以告诉sql server 2000中R树的sql查询.

Can anyone tell the sql query for R Tree in Sql server 2000.

推荐答案

R树是专门用于进行范围查询的特殊索引. R树在地理空间系统中最常用，其中每个条目都是一个具有最小和最大X和Y坐标的矩形.

从理论上讲，R-Tree索引也可以基于一维数据构建，但是主要的四个数据库都不支持它.参考: http://explainextended.com/2009/08/11/efficiency -date-range-query-sql-server/ [ ^ ]

An R-Tree is a special index that is designed for doing range queries. R-Trees are most commonly used in geospatial systems where each entry is a rectangle with minimum and maximum X and Y coordinates.

In theory, an R-Tree index could be built over 1-dimensional data just as well, but no database of the major four supports it. Reference: http://explainextended.com/2009/08/11/efficient-date-range-query-sql-server/[^]

这篇关于在SQL Server 2000中查询R树的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！