<div>
<div class="content wysiwyg-content">
I have a Database of points(x,y) coordinates.<br />
<br />
The application queries the database and returns an average of 30 000 points in each query.<br />
<br />
What is the optimal spatial index setup. I am reffering to the Grid Tesseleation settings and number of tiles per object etc.<br />
<br />
Thank you.<br />
<br />

</div>
</div>


I have a Database of points(x,y) coordinates.

The application queries the database and returns an average of 30 000 points in each query.

What is the optimal spatial index setup. I am reffering to the Grid Tesseleation settings and number of tiles per object etc.

Thank you.



SQL 2008 Spatial Index Optomization

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

The Global Positioning System (GPS) is a space-based global navigation satellite system (GNSS) that provides reliable location and time information in all weather and at all times and anywhere on or near the Earth when and where there is an unobstructed line of sight to four or more GPS satellites. A geographic information system (GIS) or geospatial information system is any system that captures, stores, analyzes, manages, and presents data that are linked to location(s). In the simplest terms, GIS is the merging of cartography, statistical analysis, and database technology.