Click here to Skip to main content
14,667,145 members
Rate this:
Please Sign up or sign in to vote.
See more:
Can anyone tell the sql query for R Tree in Sql server 2000.
Posted

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

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/[^]
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100