SQL Server DATA DICTIONARY keyword
SQL Server DATA DICTIONARY keyword
|
| Release 9.3 |
   |
Note:This topic was updated for 9.3.1.
NOTE: Applies to geodatabases created with an ArcGIS Server Enterprise license only
You can use the DATA_DICTIONARY parameters to set fill factors for system indexes or to specify locations for system tables. You need to alter these parameters in the dbtune.sde file prior to creating your geodatabase since they affect the storage of 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
