How can I create a Spatial Index for a SQL Geometry Table?
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.