I have a SQL Server 2008/SDE 10 database and I'm trying to set the dbtune parameters for the spatial index (A_MS_SPINDEX & B_MS_SPINDEX) but need to specify the filegroup in the index creation statement as we ideally want to separate index and data storage. For other index parameters you simply append the filegroup to the index parameter.
For example:
B_INDEX_SHAPE "WITH FILLFACTOR = 75 on MYFILEGROUPNAME"
So can I just append the filegroup to the A_MS_SPINDEX/B_MS_SPINDEX parameters in a similar way? For example:
I'm not convinced this will work in the same way as other indexes, because of the way in which the create spatial index statement is formatted. Does anyone have any thoughts on this? I don't really want to have to re-create the spatial indexes outside of ArcGIS, just to ensure the correct storage parameters.
Unfortunately, this is a known limitation for the MS spatial index parameters for now. The A_MS_SPINDEX & B_MS_SPINDEX will only control the WITH option in the CREATE SPATIAL INDEX statement. Please also refer to http://msdn.microsoft.com/en-us/library/bb934196.aspx
Unfortunately, this is a known limitation for the MS spatial index parameters for now. The A_MS_SPINDEX & B_MS_SPINDEX will only control the WITH option in the CREATE SPATIAL INDEX statement. Please also refer to http://msdn.microsoft.com/en-us/library/bb934196.aspx
I usually construct my own index commands in SQL, and only register with ArcSDE after everything is to my liking. There's no law that says you can't drop and rebuild indexes after ArcGIS is done loading...
