La palabra clave de configuración DEFAULTS en SQL Server

Como su nombre lo indica, la configuración en la palabra clave de configuración DEFAULTS se utiliza por defecto cuando crea tablas, clases de entidad, datasets ráster e índices. Si no especifica una palabra clave diferente cuando se crean los datos en la geodatabase, o si especifica una palabra clave a la que le faltan parámetros necesarios, se utilizan valores de la palabra clave DEFAULTS.

Los parámetros agrupados en la palabra clave DEFAULTS se deben configurar en valores que se apliquen a la mayoría de los datos en su geodatabase. Los siguientes valores están presentes en la tabla SDE_dbtune si no la personaliza.

##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_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 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       "SDEBINARY" GEOMTAB_OUT_OF_ROW	0 GEOMTAB_PK				"WITH FILLFACTOR = 75" GEOMTAB_STORAGE		"" PERMISSION_CACHE_THRESHOLD  250 UNICODE_STRING   "TRUE" COLLATION_NAME   "" XMLCOLUMN_STORAGE			"DB_XML" XMLCOLUMN_SCHEMA	"" XMLCOLUMN_TYPE			"" XMLCOLUMN_PRIMARY_IDX	0 XMLCOLUMN_PATH_IDX		    0 XMLCOLUMN_PROPERTY_IDX	0  XMLCOLUMN_VALUE_IDX	 	0  RASTER_STORAGE   "BINARY"  END