Abstract | ||
---|---|---|
Microsoft SQL Server 2008 adds built-in support for 2-dimensional spatial data types for both planar and geodetic geometries to address the increasing demands for managing location-aware data. SQL Server 2008 also adds indexing capabilities that, together with the necessary plan selections done by the query optimizer, provide efficient processing of spatial queries. This paper will present an overview of the spatial indexing implementation in SQL Server 2008 and outline how the indexing is implemented and how the cost-based query optimizer chooses among the different plans. |
Year | DOI | Venue |
---|---|---|
2008 | 10.1145/1376616.1376737 | SIGMOD Conference |
Keywords | Field | DocType |
microsoft sql server,different plan,cost-based query optimizer,spatial query,2-dimensional spatial data type,spatial indexing implementation,location-aware data,sql server,built-in support,query optimizer,spatial database,2 dimensional,indexation,query optimization,spatial index | Query optimization,Data mining,Information retrieval,Computer science,Language Integrated Query,In-Memory Processing,Data Transformation Services,Query by Example,User-defined function,Spatial query,Spatial database,Database | Conference |
Citations | PageRank | References |
22 | 1.00 | 21 |
Authors | ||
5 |
Name | Order | Citations | PageRank |
---|---|---|---|
Yi Fang | 1 | 22 | 1.00 |
Marc Friedman | 2 | 487 | 48.32 |
Giri Nair | 3 | 22 | 1.00 |
Michael Rys | 4 | 244 | 44.21 |
Ana-Elisa Schmid | 5 | 22 | 1.00 |