October 22, 2018 at 7:28 am
Does Spatial Indexes require any maintenance like rebuilds/reorganize/updates to keep beeing optimal.
SQL Server Books online are quite silent on this topic ?
Thanks.
Tomasz
October 22, 2018 at 12:31 pm
It's a somewhat tough subject to address. I'd say, make sure, just like any index, that the statistics are up to date. That's more important than anything else.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 23, 2018 at 1:18 am
Alright did some testing this morning and here is what I have established:
The update stats on the inses does not work and ends with error claiming is is not an statistics collection.
The sys.dm_db_index_physical_stats do show meaningful values in avg_fragmentation_in_percent columns and after some inserts the fragmentation does rise.
From that point the reorganize/rebuild does seems to improve things and I can see the avg_fragmentation_in_percent dropping after I use those.
Will probably follow the usual approach as with ordinary indexes.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply