You cannot place a multi-versioned ArcSDE feature class into load_only_io. What are some database maintenance operations I should periodically perform?
If you data is highly dynamic, you should monitor table fragmentation with DBCC showcontig (‘table_id’). Consult the MS SQL Server 7.0 Books online for detailed information about this command. If you find that your tables are fragmented, recreate your indexes using the above script, placing your layers into load_only_io and then back to normal_io, or by running dbcc dbreindex. You should also run ‘update statistics’ or sp_updatestats periodically to rebuild index key value distributions.
Related Questions
- You cannot place a multi-versioned ArcSDE feature class into load_only_io. What are some database maintenance operations I should periodically perform?
- I can export a feature layer to a shapefile, ArcSDE, and to a personal geodatabase, but can I create a feature class in my Coverage?
- In ArcGIS, how do I add an area or perimeter field to a shapefile or feature class?
