The DEFAULTS keyword in SQL Server

As the name indicates, the settings under the DEFAULTS configuration keyword are used by default when you create tables, feature classes, raster datasets, and indexes. If you do not specify a different keyword when data is created in the geodatabase, or if you specify a keyword that is missing some necessary parameters, values from the DEFAULTS keyword are used.

The parameters grouped under the DEFAULTS keyword should be set to values that apply to most of the data in your geodatabase. The following values are present in the SDE_dbtune table if you do not customize it.

##DEFAULTS

NUM_DEFAULT_CURSORS	-1
CROSS_DB_QUERY_FILTER  0
UI_TEXT	"User Interface text for DEFAULTS"
A_CLUSTER_ROWID	0
A_CLUSTER_SHAPE	1
A_CLUSTER_STATEID	0
A_CLUSTER_USER	0
A_CLUSTER_XML  0
A_CLUSTER_RASTER  0
A_INDEX_ROWID	"WITH FILLFACTOR = 75"
A_INDEX_SHAPE	"WITH FILLFACTOR = 75"
A_INDEX_STATEID	"WITH FILLFACTOR = 75"
A_INDEX_USER	"WITH FILLFACTOR = 75"
A_INDEX_XML	"WITH FILLFACTOR = 75"
A_INDEX_RASTER	"WITH FILLFACTOR = 75"
A_MS_SPINDEX    "GRIDS = (MEDIUM, MEDIUM, MEDIUM, MEDIUM), CELLS_PER_OBJECT = 16"
A_OUT_OF_ROW   0
A_STORAGE	""
B_CLUSTER_ROWID	0
B_CLUSTER_SHAPE	1
B_CLUSTER_USER	0
B_CLUSTER_XML 0
B_CLUSTER_RASTER 0
B_CLUSTER_TO_DATE  0
B_INDEX_ROWID	"WITH FILLFACTOR = 75"
B_INDEX_SHAPE	"WITH FILLFACTOR = 75"
B_INDEX_USER	"WITH FILLFACTOR = 75"
B_INDEX_XML	"WITH FILLFACTOR = 75"
B_INDEX_RASTER	"WITH FILLFACTOR = 75"
B_INDEX_TO_DATE "WITH FILLFACTOR = 75"
B_MS_SPINDEX    "GRIDS = (MEDIUM, MEDIUM, MEDIUM, MEDIUM), CELLS_PER_OBJECT = 16"
B_STORAGE	""
B_OUT_OF_ROW   0
I_STORAGE  ""
D_CLUSTER_ALL	0
D_CLUSTER_DELETED_AT	1
D_INDEX_ALL	"WITH FILLFACTOR = 75"
D_INDEX_DELETED_AT	"WITH FILLFACTOR = 75"
D_STORAGE	""
F_CLUSTER_FID	1
F_INDEX_AREA	"WITH FILLFACTOR = 75"
F_INDEX_FID	"WITH FILLFACTOR = 75"
F_INDEX_LEN	"WITH FILLFACTOR = 75"
F_STORAGE	""
F_OUT_OF_ROW   0
S_CLUSTER_ALL	1
S_CLUSTER_SP_FID	0
S_INDEX_ALL	"WITH FILLFACTOR = 75"
S_INDEX_SP_FID	"WITH FILLFACTOR = 75"
S_STORAGE	""
RAS_STORAGE       ""
RAS_CLUSTER_ID   1
RAS_INDEX_ID    "WITH FILLFACTOR = 75"
BND_STORAGE       ""
BND_CLUSTER_ID   0
BND_INDEX_ID    "WITH FILLFACTOR = 75"
BND_CLUSTER_COMPOSITE   0
BND_INDEX_COMPOSITE    "WITH FILLFACTOR = 75"
AUX_STORAGE       ""
AUX_CLUSTER_COMPOSITE   1
AUX_INDEX_COMPOSITE    "WITH FILLFACTOR = 75"
BLK_STORAGE       ""
BLK_CLUSTER_COMPOSITE   1
BLK_INDEX_COMPOSITE    "WITH FILLFACTOR = 75"
BLK_OUT_OF_ROW   0
XML_DOC_INDEX	"WITH FILLFACTOR = 75"
XML_DOC_STORAGE	""
XML_DOC_OUT_OF_ROW	0
XML_DOC_UNCOMPRESSED_TYPE	"BINARY"
XML_IDX_CLUSTER_DOUBLE	0
XML_IDX_CLUSTER_ID			0
XML_IDX_CLUSTER_PK			1
XML_IDX_CLUSTER_STRING	0
XML_IDX_CLUSTER_TAG		0
XML_IDX_FULLTEXT_CAT		"SDE_DEFAULT_CAT"
XML_IDX_FULLTEXT_LANGUAGE
XML_IDX_FULLTEXT_TIMESTAMP	1
XML_IDX_FULLTEXT_UPDATE_METHOD 		"CHANGE_TRACKING BACKGROUND"
XML_IDX_INDEX_DOUBLE	"WITH FILLFACTOR = 75"
XML_IDX_INDEX_ID		"WITH FILLFACTOR = 75"
XML_IDX_INDEX_PK		"WITH FILLFACTOR = 75"
XML_IDX_INDEX_STRING	"WITH FILLFACTOR = 75"
XML_IDX_INDEX_TAG	"WITH FILLFACTOR = 75"
XML_IDX_STORAGE
XML_IDX_OUT_OF_ROW	0
GEOM_SRID_CHECK			1
GEOMETRY_STORAGE       "GEOMETRY"
GEOMTAB_OUT_OF_ROW	0
GEOMTAB_PK				"WITH FILLFACTOR = 75"
GEOMTAB_STORAGE		""
PERMISSION_CACHE_THRESHOLD  250
UNICODE_STRING   "TRUE"
COLLATION_NAME   ""
XML_COLUMN_STORAGE			"DB_XML"
XML_COLUMN_SCHEMA	""
XML_COLUMN_TYPE			""
XML_COLUMN_PRIMARY_IDX	0
XML_COLUMN_PATH_IDX		    0
XML_COLUMN_PROPERTY_IDX	0 
XML_COLUMN_VALUE_IDX	 	0 
RASTER_STORAGE   "BINARY"

END