The DATA_DICTIONARY keyword in SQL Server
The DATA_DICTIONARY keyword contains parameters that determine the storage settings for specific ArcSDE geodatabase system tables.
In geodatabases in SQL Server, you can use the DATA_DICTIONARY parameters to set fill factors for system indexes or to specify locations for system tables.
If your site makes extensive use of versioned editing, consider separating the SDE_MVTABLES_MODIFIED, SDE_STATE_LINEAGES, and SDE_STATES tables and indexes into their own file groups to reduce I/O contention.
##DATA_DICTIONARY B_CLUSTER_ROWID 0 B_CLUSTER_USER 0 B_INDEX_ROWID "WITH FILLFACTOR = 75" B_INDEX_USER "WITH FILLFACTOR = 75" B_STORAGE "" MVTABLES_MODIFIED_INDEX "WITH FILLFACTOR = 75" MVTABLES_MODIFIED_TABLE "" STATE_LINEAGES_INDEX "WITH FILLFACTOR = 75" STATE_LINEAGES_TABLE "" STATES_INDEX "WITH FILLFACTOR = 75" STATES_TABLE "" VERSIONS_INDEX "WITH FILLFACTOR = 75" VERSIONS_TABLE "" XML_INDEX_TAGS_TABLE "" XML_INDEX_TAGS_INDEX "WITH FILLFACTOR = 75" END
Related Topics
8/19/2013