I am looking to turn page compression on on a spatial index. The instance is 2008 Enterprise. The index is pre-existing on a vendor supplied app. In searching through BOL, it states that compression and fillfactor are both allowed.
ALTER INDEX [ix_city_citypoint] on city REBUILD WITH (FILLFACTOR = 90, DATA_COMPRESSION = PAGE)
Msg 153, Level 15, State 4, Line 12
Invalid usage of the option data_compression in the ALTER INDEX REBUILD statement.
CREATE SPATIAL INDEX [ix_city_citypoint] ON [dbo].[city] ( [citypoint] )USING GEOGRAPHY_GRID WITH (GRIDS =(LEVEL_1 = MEDIUM,LEVEL_2 = MEDIUM,LEVEL_3 = MEDIUM,LEVEL_4 = MEDIUM), CELLS_PER_OBJECT = 16, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF , SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF , ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [primary] GO
I can always ignore the index as it's small but now it's morphed into one of those "teachable" moments. Thank you for any insight