MapThat Admin – Create a Spatial Index for a SQL Geometry Table

Question: 

How can I create a Spatial Index for a SQL Geometry Table?

Answer:

Firstly, you will need to calculate the Bounding Box for the geometry within your SQL table. Use the following SQL statement and change the Your_TableName where required:

The results of this will identify the co-ordinates of the bounding box around your geometry.

Using the SQL statement below you can now generate the Spatial Index. Simply change the Your_TableName as required and insert the coordinates to specify your tables bounding box (as identified in the last step):

The Spatial Index will now be created and can be seen within the Indexes section of your tables properties.