SQL 2008 Spatial Index Optomization

EasyToHelp used Ask the Experts™
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.

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
When a spatial index is created, it first performs the refactoring of space. It then performs a tessellation process, whereby it fits the space represented by the data into the previously created grid hierarchy without gaps or overlaps.

The covering rule       If an object completely covers a cell and overlaps into other cells then the cell is recorded in the index and no other attempt is made to maneuver other objects against that cell
The cells-per-object rule       A limit on the number of objects that tessellation can occur with in a given cell. This limitation is enforced in all levels except for Level One and can be customized when creating the index (the maximum values is 8192)
The deepest-cell rule       This rule takes advantage of the hierarchical model mentioned earlier by recording only the information required in the deepest cell

Reference: http://www.mssqltips.com/tip.asp?tip=1976

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial