• Blog posts



    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.





Please sign in to leave a comment.