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